{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Commercial","Gas Support","Sheet1","Flex Face Dimensions","GS Placement A","GS Placement B","GS Placement C"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":1,"defined_names":95,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Commercial","index":0,"n_rows":141,"n_cols":38,"rows_kept":141,"cut":false,"hidden":false,"merged":[[77,36,77,41],[45,36,45,41],[79,31,79,41],[84,31,84,33],[84,34,84,38],[31,37,31,39],[24,37,24,38],[25,37,25,38],[47,1,47,28],[24,2,24,3],[41,32,41,35],[42,36,42,43],[40,7,40,25],[42,2,42,3],[38,1,38,28],[39,2,39,3],[43,2,43,3],[39,5,39,6],[43,5,43,6],[43,7,43,25],[39,7,39,28],[40,2,40,3],[40,5,40,6],[83,1,83,28],[37,36,37,39],[29,37,29,39],[24,32,24,33],[29,33,29,34],[31,33,31,34],[32,33,32,34],[35,32,35,36],[36,1,36,28],[37,15,37,22],[37,1,37,3],[37,23,37,28],[37,5,37,12],[68,5,68,6],[68,7,68,10],[68,11,68,12],[68,13,68,16],[23,5,23,6],[24,5,24,6],[27,2,27,3],[41,5,41,6],[41,7,41,25],[50,7,50,25],[50,2,50,3],[49,5,49,6],[23,7,23,28],[27,7,27,25],[49,2,49,3],[25,5,25,6],[25,7,25,25],[27,5,27,6],[25,2,25,3],[34,1,34,28],[64,1,64,28],[68,17,68,18],[48,1,48,28],[16,2,16,3],[16,5,16,6],[24,7,24,25],[26,2,26,3],[26,5,26,6],[26,7,26,25],[67,26,67,28],[73,4,73,25],[72,28,77,28],[32,2,32,3],[33,1,33,28],[32,4,32,25],[56,5,56,6],[55,5,55,6],[74,4,74,25],[77,4,77,25],[41,2,41,3],[56,2,56,3],[67,5,67,13],[67,14,67,17],[67,18,67,25],[35,1,35,28],[72,4,72,25],[70,1,70,28],[18,1,18,28],[19,1,20,28],[17,7,17,25],[31,2,31,3],[29,1,29,28],[31,4,31,28],[30,1,30,28],[21,1,21,28],[22,1,22,28],[23,2,23,3],[28,1,28,28],[1,1,1,28],[15,5,15,6],[15,7,15,28],[6,18,6,25],[7,1,7,4],[4,1,4,28],[5,1,5,28],[2,1,2,28],[6,1,6,4],[6,5,6,13],[7,17,7,18],[15,2,15,3],[7,5,7,6],[6,14,6,17],[7,11,7,12],[7,7,7,10],[7,13,7,16],[7,19,7,25],[8,1,8,25],[10,1,10,28],[14,1,14,28],[3,1,3,28],[6,28,8,28],[13,5,13,10],[6,30,6,33],[7,30,7,33],[4,34,4,37],[62,1,62,28],[63,1,63,28],[65,1,65,28],[4,30,4,33],[5,30,5,33],[6,26,8,26],[6,27,8,27],[9,1,9,28],[11,1,12,28],[44,1,44,28],[49,7,49,25],[16,7,16,25],[17,2,17,3],[42,5,42,6],[42,7,42,25],[8,30,8,34],[17,5,17,6],[19,32,19,37],[55,30,55,33],[56,30,56,33],[45,1,45,28],[79,28,80,28],[82,1,82,28],[85,1,85,28],[80,2,80,3],[86,4,86,25],[87,1,87,28],[88,2,88,3],[75,2,75,3],[81,1,81,28],[76,2,76,3],[76,4,76,25],[79,2,79,3],[75,4,75,25],[77,2,77,3],[88,4,88,25],[86,2,86,3],[80,4,80,25],[110,1,110,28],[95,2,95,3],[98,4,98,25],[95,4,95,25],[88,28,95,28],[97,2,97,3],[93,4,93,25],[97,4,97,25],[89,2,89,3],[90,2,90,3],[90,4,90,25],[91,2,91,3],[100,4,100,25],[89,4,89,25],[99,2,99,3],[99,4,99,25],[94,2,94,3],[92,4,92,25],[91,4,91,25],[21,32,21,34],[40,36,40,42],[41,36,41,42],[43,36,43,42],[39,36,39,42],[57,1,57,28],[58,5,58,6],[58,7,58,25],[78,1,78,28],[58,2,58,3],[71,1,71,28],[72,2,72,3],[73,2,73,3],[68,1,68,4],[50,5,50,6],[56,7,56,25],[66,1,66,28],[55,7,55,25],[67,1,67,4],[55,2,55,3],[74,2,74,3],[69,1,69,28],[51,1,51,28],[54,1,54,28],[13,12,13,17],[13,18,13,28],[109,4,109,25],[103,28,109,28],[109,2,109,3],[103,2,103,3],[104,2,104,3],[105,2,105,3],[106,2,106,3],[107,2,107,3],[108,2,108,3],[103,4,103,25],[104,4,104,25],[105,4,105,25],[106,4,106,25],[107,4,107,25],[108,4,108,25],[94,4,94,25],[68,19,68,28],[79,4,79,25],[84,2,84,3],[84,4,84,25],[101,2,101,3],[98,2,98,3],[120,1,120,28],[121,1,121,28],[122,1,122,28],[123,1,123,28],[124,1,124,28],[52,1,53,28],[46,1,46,28],[82,31,82,34],[82,35,82,38],[111,31,111,32],[112,1,112,28],[113,2,113,3],[114,2,114,3],[113,4,113,25],[114,4,114,25],[101,4,101,25],[97,28,101,28],[92,2,92,3],[93,2,93,3],[96,1,96,28],[111,2,111,3],[111,4,111,25],[100,2,100,3],[102,1,102,28],[125,1,125,4],[125,5,125,13],[125,14,125,17],[125,18,125,25],[125,26,125,28],[126,1,126,4],[126,5,126,6],[126,7,126,10],[126,11,126,12],[126,13,126,16],[126,17,126,18],[126,19,126,28],[127,1,127,28],[128,1,128,28],[130,2,130,3],[131,2,131,3],[132,2,132,3],[133,2,133,3],[134,2,134,3],[135,2,135,3],[136,2,136,3],[130,10,130,11],[137,2,137,3],[138,2,138,3],[139,2,139,3],[140,2,140,3],[130,6,130,7],[131,6,131,7],[132,6,132,7],[133,6,133,7],[134,6,134,7],[135,6,135,7],[136,6,136,7],[137,6,137,7],[138,6,138,7],[139,6,139,7],[140,6,140,7]]}
[]
[]
[]
[null,"BILL OF MATERIAL"]
[null,{"$f":"AI5&AE5&AI6&AE6&AE9&AI8&AE8&AI7&AE7","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Slimline Single Face Body\",IF(BodyType=2,\" Narrow Single Face Body\",IF(BodyType=3,\" Single Face Body\",IF(BodyType=4,\" Medium Body\",IF(BodyType=5,\" Wide Body\",IF(BodyType=6,\" Retro Body\",IF(BodyType=7,\"  Retainer Only -\",\"\")))))))))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(PTDS=1,\"Mill Finish -\",IF(PTDS=2,\"Pre-Painted -\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=1,\" 1-1/2'' Retainer II\",IF(RETTYPE=2,\" 2-1/4'' Retainer\",IF(RETTYPE=3,\" Dual Frame and 2-1/4'' Dual Frame Cover\",IF(RETTYPE=4,\" Bleed Tension Frame and Bleed Tension Frame Cover\",IF(RETTYPE=5,\" Tension Frame and 1-1/2'' Bleed Tension Frame Cover\",IF(RETTYPE=6,\" Bleed Rigid Retainer\",IF(RETTYPE=7,\" 1-1/2'' Retainer\",IF(RETTYPE=8,\" Tension Frame II and Bleed Tension Frame Cover\",IF(RETTYPE=9,\" Tension Frame II and 1-1/2'' Bleed Tension Frame Cover\",\"\"))))))))))))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RET=1,\"\",IF(BodyType=1,\" with\",IF(BodyType=2,\" with\",IF(BodyType=3,\" with\",IF(BodyType=4,\" with\",IF(BodyType=5,\" with\",IF(BodyType=6,\" with\",IF(BodyType=7,\"\",\"\"))))))))))","v":""}]
[null,"Customer  ",null,null,null,null,null,null,null,null,null,null,null,null,"Order#   ",null,null,null,null,null,null,null,null,null,null,null,"Lengths Required","Lengths Used","Drops Used",null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=1),\" Vandal Cover\",IF(AND(INFRM=2,OTFRM=2),\" Large Vandal Cover\",\"\"))))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=1),\" with\",IF(AND(INFRM=2,OTFRM=2),\" with\",\"\")))))","v":""}]
[null,"Kit Quantity  ",null,null,null,0,null,"Height  ",null,null,null,0,null,"Width",null,null,null,0,null,"Enter Fractions as Decimals",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(RETTYPE>=4,\"\",IF(RETOPT=1,\"\",IF(AND(RETTYPE>=2,DTYP=1),\"\",IF(AND(RETTYPE=1,DTYP>=2),\"\",(IF(AND(NoYes2=2,DTYP=1),\" 1-1/2'' Divider\",(IF(AND(NoYes2=2,DTYP=2),\" 2'' Divider\",(IF(AND(NoYes2=2,DTYP=3),\" 2-3/4'' Divider\",(IF(AND(NoYes2=2,DTYP=4),\" Dual Divider and Dual Divider Cover\",\"\"))))))))))))))","v":""},null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE>=4,\"\",IF(RETOPT=1,\"\",IF(AND(RETTYPE>=2,DTYP=1),\"\",IF(AND(RETTYPE=1,DTYP>=2),\"\",(IF(AND(NoYes2=2,DTYP=1),\" and\",(IF(AND(NoYes2=2,DTYP=2),\" and\",(IF(AND(NoYes2=2,DTYP=3),\" and\",(IF(AND(NoYes2=2,DTYP=4),\" and\",\"\"))))))))))))))))","v":""}]
[null,"Add one inch (1'') the direction of the lamp when fluorescent lamps are to be used for illumination.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE>=4,\"\",IF(RETTYPE>=3,\"\",IF(RETOPT=1,\" (All Sides)\",IF(RETOPT=2,\" (One End Removable)\",IF(RETOPT=3,\" (Both Ends Removable)\",\"\"))))))))","v":""}]
[null,"Extrusions"]
[]
[null,"Body Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,"Body"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(PTDS=1,\"\",IF(PTDS=2,\"P\"))","v":""}]
[null,"Body",null,null,null,{"$f":"IF(AND(BodyType>=1,BodyType<=5,OR(BodyType=7)),\"\",IF(BodyType=6,\"Retro Body Standard Add-on\",\"\"))","v":""},null,null,null,null,null,null,{"$f":"IF(AND(BodyType>=1,BodyType<=5,OR(BodyType=7)),\"\",IF(BodyType=6,\"Retro Body No Add-on\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=6),KQ*2,IF(BodyType=7,\"\",\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=5),Wdt,IF(AND(BodyType=6,RETADD=1),Wdt+0.265,IF(AND(BodyType=6,RETADD=2),Wdt+0.14,IF(BodyType=7,\"\",\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"2020\"&PPTD,IF(BodyType=2,\"2021\"&PPTD,IF(BodyType=3,\"2025\"&PPTD,IF(BodyType=4,\"2015\"&PPTD,IF(BodyType=5,\"2005\"&PPTD,IF(BodyType=6,\"2040\",IF(BodyType=7,\"\",\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Slimline Single Face Body - Top & Bottom - Mitered Both Ends\",IF(BodyType=2,\" Narrow Single Face Body - Top & Bottom - Mitered Both Ends\",IF(BodyType=3,\" Single Face Body - Top & Bottom - Mitered both Ends\",IF(BodyType=4,\" Medium Body - Double Face - Top & Bottom - Mitered Both Ends\",IF(BodyType=5,\" Wide Body - Double Face - Top & Bottom - Mitered Both Ends\",IF(BodyType=6,\" Retro Body - Single Face - Top & Bottom - Mitered Both Ends\",\"\"))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=6),KQ*2,IF(BodyType=7,\"\",\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=5),Hgt,IF(AND(BodyType=6,RETADD=1),Hgt+0.265,IF(AND(BodyType=6,RETADD=2),Hgt+0.14,IF(BodyType=7,\"\",\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"2020\"&PPTD,IF(BodyType=2,\"2021\"&PPTD,IF(BodyType=3,\"2025\"&PPTD,IF(BodyType=4,\"2015\"&PPTD,IF(BodyType=5,\"2005\"&PPTD,IF(BodyType=6,\"2040\",IF(BodyType=7,\"\",\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Slimline Single Face Body - Ends - Mitered Both Ends\",IF(BodyType=2,\" Narrow Single Face Body - Ends - Mitered Both Ends\",IF(BodyType=3,\" Single Face Body - Ends - Mitered Both Ends\",IF(BodyType=4,\" Medium Body - Double Face - Ends - Mitered Both Ends\",IF(BodyType=5,\" Wide Body - Double Face - Ends - Mitered Both Ends\",IF(BodyType=6,\" Retro Body - Single Face - Ends - Mitered Both Ends\",\"\"))))))))","v":""}]
[]
[null,"Retainer Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"\" Use 1-1/2'' Retrainer II with One or Both Ends Removable\"","v":" Use 1-1/2'' Retrainer II with One or Both Ends Removable"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Ret"]
[null,"Retainer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"\" Select Both Ends Removable\"","v":" Select Both Ends Removable"}]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(BodyType<=3,KQ*2,IF(AND(BodyType>=4,BodyType<=5),KQ*4,IF(BodyType=6,KQ*2,IF(BodyType=7,KQ*2,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(AND(BodyType=6,RETTYPE<=2,RETADD=1)),Wdt+0.265,IF(AND(AND(BodyType=6,RETTYPE<=2,RETADD=2)),Wdt+0.14,IF(AND(AND(BodyType=6,RETTYPE=6,RETADD=1)),Wdt+0.265,IF(AND(AND(BodyType=6,RETTYPE=6,RETADD=2)),Wdt+0.14,IF(AND(AND(BodyType=6,RETTYPE=7,RETADD=1)),Wdt+0.265,IF(AND(AND(BodyType=6,RETTYPE=7,RETADD=2)),Wdt+0.14,IF(AND(AND(BodyType=6,RETADD=1,OR(RETTYPE>=3,RETTYPE<=5))),Wdt+0.115,IF(AND(AND(BodyType=6,RETADD=2,OR(RETTYPE>=3,RETTYPE<=5))),Wdt-0.01,IF(AND(AND(BodyType=6,RETADD=1,OR(RETTYPE=8,RETTYPE=9))),Wdt+0.115,IF(AND(AND(BodyType=6,RETADD=2,OR(RETTYPE=8,RETTYPE=9))),Wdt-0.01,IF(AND(BodyType=7,RETTYPE=6),Wdt,IF(RETTYPE<=2,Wdt,IF(AND(RETTYPE>=3,RETTYPE<=5),Wdt-0.15,IF(RETTYPE=6,Wdt,IF(RETTYPE=7,Wdt,IF(AND(RETTYPE>=8,RETTYPE<=9),Wdt-0.15,\"\")))))))))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=1,\"2053\"&PPTD,IF(RETTYPE=2,\"2045\"&PPTD,IF(RETTYPE=3,\"2065\",IF(RETTYPE=4,\"2085\",IF(RETTYPE=5,\"2085\",IF(RETTYPE=6,\"2048\",IF(RETTYPE=7,\"2055\"&PPTD,IF(RETTYPE=8,\"2086\",IF(RETTYPE=9,\"2086\",\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(RETTYPE=1,DTYP>=2),\" Select 1-1/2'' Divider\",IF(AND(AND(RETTYPE=1,RETOPT=1,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(RETTYPE=7,NoYes2=2),\" Use 1-1/2'' Retrainer II with One or Both Ends Removable\",IF(RETTYPE=1,\" 1-1/2'' Retainer II - Top and Bottom - Mitered Both Ends\",IF(RETTYPE=2,\" 2-1/4'' Retainer - Top and Bottom - Mitered Both Ends\",IF(RETTYPE=3,\" Dual Frame - Top and Bottom - Mitered Both Ends\",IF(RETTYPE=4,\" Tension Frame - Top and Bottom - Mitered Both Ends\",IF(RETTYPE=5,\" Tension Frame - Top and Bottom - Mitered Both Ends\",IF(RETTYPE=6,\" Bleed Rigid Retainer - Top and Bottom - Mitered Both Ends\",IF(RETTYPE=7,\" 1-1/2'' Retainer - Top and Bottom - Mitered Both Ends\",IF(RETTYPE=8,\" Tension Frame II - Top and Bottom - Mitered Both Ends\",IF(RETTYPE=9,\" Tension Frame II - Top and Bottom - Mitered Both Ends\",\"\")))))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frame Braces",null,{"$f":"(THFB+TVFB)*2","v":0},{"$f":"IF(Hgt<=48,0,CEILING(HFB,1))","v":0},{"$f":"IF(Hgt<=71,\"0\",ROUNDDOWN(Hgt/37,0))","v":"0"}," Horz. Frame Braces"]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=7,\"\",IF(AND(RETTYPE=1,RETOPT=2),RETQTY,IF(AND(RETTYPE=2,RETOPT=2),RETQTY,IF(RETTYPE<=2,\"\",IF(RETTYPE=6,\"\",IF(BodyType<=3,KQ*2,IF(AND(BodyType>=4,BodyType<=5),KQ*4,IF(BodyType=6,KQ*2,IF(BodyType=7,KQ*2,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=6,\"\",IF(RETTYPE=7,\"\",IF(AND(RETTYPE<=2,RETOPT=1),\"\",IF(AND(RETOPT=3,RETTYPE<=2),\"\",IF(AND(RETTYPE=1,RETOPT=2),RETHGT,IF(AND(RETTYPE=2,RETOPT=2),RETHGT,IF(AND(AND(BodyType=6,RETADD=1,OR(RETTYPE>=3,RETTYPE<=5))),Wdt+0.265,IF(AND(AND(BodyType=6,RETADD=2,OR(RETTYPE>=3,RETTYPE<=5))),Wdt+0.14,IF(AND(RETTYPE>=3,RETTYPE<=5),Wdt,IF(AND(AND(BodyType=6,RETADD=1,OR(RETTYPE>=8,RETTYPE<=9))),Wdt+0.265,IF(AND(AND(BodyType=6,RETADD=2,OR(RETTYPE>=8,RETTYPE<=9))),Wdt+0.14,IF(AND(RETTYPE>=8,RETTYPE<=9),Wdt,\"\")))))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=7,\"\",IF(AND(RETTYPE=1,RETOPT=2),\"2053\"&PPTD,IF(AND(RETTYPE=2,RETOPT=2),\"2045\"&PPTD,IF(RETTYPE<=2,\"\",IF(RETTYPE=3,\"2075\"&PPTD,IF(RETTYPE=4,\"2095\"&PPTD,IF(RETTYPE=5,\"2084\"&PPTD,IF(RETTYPE=8,\"2095\"&PPTD,IF(RETTYPE=9,\"2084\"&PPTD,\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=7,\"\",IF(AND(RETTYPE=1,DTYP>=2),\" Select 1-1/2'' Divider\",IF(AND(AND(RETTYPE=2,DTYP=1,NoYes2=2)),\" Select 2'' Divider or 2-3/4'' Divider or Dual Divider and Dual Divder Cover\",IF(AND(AND(RETTYPE=1,RETOPT=1,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=1,RETOPT=2,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=2,RETOPT=1,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(RETTYPE=1,RETOPT=2),\" 1-1/2'' Retainer II - One End - Both Ends Mitered\",IF(AND(RETTYPE=2,RETOPT=2),\" 2-1/4'' Retainer - One End - Mitered Both Ends\",IF(RETTYPE<=2,\"\",IF(RETTYPE=3,\" 2-1/4'' Dual Frame Cover - Top and Bottom - Mitered Both Ends\",IF(RETTYPE=4,\" Bleed Tension Frame Cover - Top and Bottom - Mitered Both Ends\",IF(RETTYPE=5,\" 1-1/2'' Tension Frame Cover - Top and Bottom - Mitered Both Ends\",IF(RETTYPE=8,\" Bleed Tension Frame Cover - Top and Bottom - Mitered Both Ends\",IF(RETTYPE=9,\" 1-1/2'' Tension Frame Cover - Top and Bottom - Mitered Both Ends\",\"\"))))))))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BodyType<=3,KQ,IF(AND(BodyType>=4,BodyType<=5),KQ*2,IF(BodyType=6,KQ,IF(BodyType=7,KQ,\"\"))))","v":0},{"$f":"IF(AND(BodyType=6,RETADD=1),Hgt+0.265,IF(AND(BodyType=6,RETADD=2),Hgt+0.14,Hgt))","v":0},null,null,null,{"$f":"IF(Wdt<=48,0,CEILING(VFB,1))","v":0},{"$f":"IF(Wdt<=71,\"0\",ROUNDDOWN(Wdt/37,0))","v":"0"}," Vert. Frame Braces"]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(RETTYPE=1,RETOPT=2),RETQTY,IF(AND(RETTYPE=2,RETOPT=2),RETQTY,IF(BodyType<=3,KQ*2,IF(AND(BodyType>=4,BodyType<=5),KQ*4,IF(BodyType=6,KQ*2,IF(BodyType=7,KQ*2,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(BodyType=6,RETTYPE=1),OHRET,IF(AND(BodyType=6,RETTYPE=2),TQRET,IF(AND(AND(BodyType=6,RETADD=1,RETTYPE=6)),Hgt+0.265,IF(AND(AND(BodyType=6,RETADD=2,RETTYPE=6)),Hgt+0.14,IF(AND(AND(BodyType=6,RETADD=1,RETTYPE=7)),Hgt+0.265,IF(AND(AND(BodyType=6,RETADD=2,RETTYPE=7)),Hgt+0.14,IF(AND(BodyType=7,RETTYPE=1),OHRET,IF(AND(BodyType=7,RETTYPE=2),TQRET,IF(AND(AND(BodyType=6,RETADD=1,OR(RETTYPE>=3,RETTYPE<=5))),Hgt+0.115,IF(AND(AND(BodyType=6,RETADD=2,OR(RETTYPE>=3,RETTYPE<=5))),Hgt-0.01,IF(AND(AND(BodyType=6,RETADD=1,OR(RETTYPE>=8,RETTYPE<=9))),Hgt+0.115,IF(AND(AND(BodyType=6,RETADD=2,OR(RETTYPE>=8,RETTYPE<=9))),Hgt-0.01,IF(AND(BodyType=7,RETTYPE=6),Hgt,IF(AND(BodyType=7,RETTYPE=7),Hgt,IF(BodyType=7,Hgt-0.15,IF(AND(RETTYPE=1,RETOPT=1),Hgt,IF(AND(RETTYPE=1,RETOPT>=2),Hgt-0.125,IF(AND(RETTYPE=2,RETOPT=1),Hgt,IF(AND(RETTYPE=2,RETOPT>=2),Hgt-0.15,IF(AND(RETTYPE>=3,RETTYPE<=5),Hgt-0.15,IF(AND(RETTYPE>=8,RETTYPE<=9),Hgt-0.15,IF(RETTYPE=6,Hgt,IF(RETTYPE=7,Hgt,\"\"))))))))))))))))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(RETTYPE=1,RETOPT=1),\"2053\"&PPTD,IF(AND(RETTYPE=1,RETOPT=2),\"2063\",IF(AND(RETTYPE=1,RETOPT=3),\"2063\",IF(AND(RETTYPE=2,RETOPT=1),\"2045\"&PPTD,IF(AND(RETTYPE=2,RETOPT=2),\"2065\",IF(AND(RETTYPE=2,RETOPT=3),\"2065\",IF(RETTYPE=3,\"2065\",IF(RETTYPE=4,\"2085\",IF(RETTYPE=5,\"2085\",IF(RETTYPE=6,\"2048\",IF(RETTYPE=7,\"2055\"&PPTD,IF(RETTYPE=8,\"2086\",IF(RETTYPE=9,\"2086\",\"\"))))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(RETTYPE=7,NoYes2=2),\" Use 1-1/2'' Retrainer II with One or Both Ends Removable\",IF(AND(RETTYPE=1,DTYP>=2),\" Select 1-1/2'' Divider\",IF(AND(AND(RETTYPE=2,NoYes2=2,DTYP=1)),\" Select 2'' Divider or 2-3/4'' Divider or Dual Divider and Dual Divder Cover\",IF(AND(AND(RETTYPE=1,RETOPT=1,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=1,RETOPT=2,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=1,RETOPT=1,HD=TRUE)),\" Select either One End or Both Ends Removable\",IF(AND(AND(RETTYPE=2,RETOPT=1,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=1,RETOPT=2,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(RETTYPE=1,RETOPT=1),\" 1-1/2'' Retainer II - Both Ends - Mitered both ends\",IF(AND(RETTYPE=1,RETOPT=2),\" 1-1/2'' Frame - One End - Mitered Both Ends\",IF(AND(AND(RETTYPE=2,RETOPT=1,HD=TRUE)),\" Select either One End or Both Ends Removable\",IF(AND(RETTYPE=1,RETOPT=3),\" 1-1/2'' Frame - Both Ends - Both Ends Mitered\",IF(AND(RETTYPE=2,RETOPT=1),\" 2-1/4'' Retainer - Both Ends - Mitered Both Ends\",IF(AND(RETTYPE=2,RETOPT=2),\" Dual Frame - One End - Mitered Both Ends\",IF(AND(RETTYPE=2,RETOPT=3),\" Dual Frame - Both Ends - Both Ends Mitered\",IF(RETTYPE=3,\" Dual Frame - Both Ends - Mitered Both Ends\",IF(RETTYPE=4,\" Tension Frame - Both ends - Mitered Both Ends\",IF(RETTYPE=5,\" Tension Frame - Both Ends - Mitered Both Ends\",IF(RETTYPE=6,\" Bleed Rigid Retainer - Both Ends - Mitered Both Ends\",IF(RETTYPE=7,\" 1-1/2'' Retainer - Both Ends - Mitered Both Ends\",IF(RETTYPE=8,\" Tension Frame II - Both ends - Mitered Both Ends\",IF(RETTYPE=9,\" Tension Frame II - Both Ends - Mitered Both Ends\",\"\"))))))))))))))))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AND(BodyType=6,RETADD=1,RETOPT=1)),Hgt+0.265,IF(AND(AND(BodyType=6,RETADD=2,RETOPT=1)),Hgt+0.14,IF(AND(AND(BodyType=6,RETADD=1,RETOPT>=2)),Hgt+0.203,IF(AND(AND(BodyType=6,RETADD=2,RETOPT>=2)),Hgt+0.078,IF(AND(BodyType=7,RETOPT=1),Hgt,IF(AND(BodyType=7,RETOPT>=2),Hgt-0.125,\"\"))))))","v":""},{"$f":"IF(AND(AND(BodyType=6,RETADD=1,RETOPT=1)),Hgt+0.265,IF(AND(AND(BodyType=6,RETADD=2,RETOPT=1)),Hgt+0.14,IF(AND(AND(BodyType=6,RETADD=1,RETOPT>=2)),Hgt+0.115,IF(AND(AND(BodyType=6,RETADD=2,RETOPT>=2)),Hgt-0.01,IF(AND(BodyType=7,RETOPT=1),Hgt,IF(AND(BodyType=7,RETOPT>=2),Hgt-0.15,\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=7,\"\",IF(AND(RETTYPE<=2,RETOPT=1),\"\",IF(AND(RETTYPE=1,RETOPT=2),RETQTY,IF(AND(RETTYPE=2,RETOPT=2),RETQTY,IF(RETTYPE=6,\"\",IF(BodyType<=3,KQ*2,IF(AND(BodyType>=4,BodyType<=5),KQ*4,IF(BodyType=6,KQ*2,IF(BodyType=7,KQ*2,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=6,\"\",IF(RETTYPE=7,\"\",IF(AND(RETTYPE<=2,RETOPT=1),\"\",IF(AND(BodyType=6,RETTYPE=1),IHCVR,IF(AND(BodyType=6,RETTYPE=2),TQCVR,IF(AND(BodyType=7,RETTYPE=1),IHCVR,IF(AND(BodyType=7,RETTYPE=2),TQCVR,IF(AND(AND(BodyType=6,RETADD=1,RETTYPE>=3)),Hgt+0.265,IF(AND(AND(BodyType=6,RETADD=2,RETTYPE>=3)),Hgt+0.14,IF(BodyType=7,Hgt,IF(AND(RETTYPE=1,RETOPT=1),Hgt,IF(AND(RETTYPE=1,RETOPT>=2),Hgt,IF(AND(RETTYPE=2,RETOPT=1),Hgt,IF(AND(RETTYPE=2,RETOPT>=2),Hgt,IF(AND(RETTYPE>=3,RETTYPE<=5),Hgt,IF(AND(RETTYPE>=8,RETTYPE<=9),Hgt,\"\")))))))))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=7,\"\",IF(AND(RETTYPE<=2,RETOPT=1),\"\",IF(AND(RETTYPE=1,RETOPT=2),\"2073\"&PPTD,IF(AND(RETTYPE=1,RETOPT=3),\"2073\"&PPTD,IF(AND(RETTYPE=2,RETOPT=2),\"2075\"&PPTD,IF(AND(RETTYPE=2,RETOPT=3),\"2075\"&PPTD,IF(RETTYPE=3,\"2075\"&PPTD,IF(RETTYPE=4,\"2095\"&PPTD,IF(RETTYPE=5,\"2084\"&PPTD,IF(RETTYPE=8,\"2095\"&PPTD,IF(RETTYPE=9,\"2084\"&PPTD,\"\"))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=7,\"\",IF(AND(RETTYPE=1,DTYP>=2),\" Select 1-1/2'' Divider\",IF(AND(AND(RETTYPE=2,NoYes2=2,DTYP=1)),\" Select 2'' Divider or 2-3/4'' Divider or Dual Divider and Dual Divder Cover\",IF(AND(AND(RETTYPE=1,RETOPT=1,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=1,RETOPT=2,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=2,RETOPT=1,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(RETTYPE<=2,RETOPT=1),\"\",IF(AND(RETTYPE=1,RETOPT=1),\" 1-1/2'' Cover - Both Ends - Mitered both ends\",IF(AND(RETTYPE=1,RETOPT=2),\" 1-1/2'' Cover - One End - Mitered Both Ends\",IF(AND(RETTYPE=1,RETOPT=3),\" 1-1/2'' Cover - Both Ends - Both Ends Mitered\",IF(AND(RETTYPE=2,RETOPT=1),\" 2-1/4'' Dual Frame Cover - Both Ends - Mitered Both Ends\",IF(AND(RETTYPE=2,RETOPT=2),\" 2-1/4'' Dual Frame Cover - One End - Mitered Both Ends\",IF(AND(RETTYPE=2,RETOPT=3),\" 2-1/4'' Dual Frame Cover - Both Ends - Both Ends Mitered\",IF(RETTYPE=3,\" 2-1/4'' Dual Frame Cover - Both Ends - Mitered Both Ends\",IF(RETTYPE=4,\" Bleed Tension Frame Cover - Both ends - Mitered Both Ends\",IF(RETTYPE=5,\" 1-1/2'' Tension Frame Cover - Both Ends - Mitered Both Ends\",IF(RETTYPE=8,\" Bleed Tension Frame Cover - Both ends - Mitered Both Ends\",IF(RETTYPE=9,\" 1-1/2'' Tension Frame Cover - Both Ends - Mitered Both Ends\",\"\"))))))))))))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AND(BodyType=6,RETADD=1,RETOPT=1)),Hgt+0.265,IF(AND(AND(BodyType=6,RETADD=2,RETOPT=1)),Hgt+0.14,IF(AND(AND(BodyType=6,RETADD=1,RETOPT>=2)),Hgt+0.265,IF(AND(AND(BodyType=6,RETADD=2,RETOPT>=2)),Hgt+0.14,IF(AND(BodyType=7,RETOPT=1),Hgt,IF(AND(BodyType=7,RETOPT>=2),Hgt,\"\"))))))","v":""},{"$f":"IF(AND(AND(BodyType=6,RETADD=1,RETOPT=1)),Hgt+0.265,IF(AND(AND(BodyType=6,RETADD=2,RETOPT=1)),Hgt+0.14,IF(AND(AND(BodyType=6,RETADD=1,RETOPT>=2)),Hgt+0.265,IF(AND(AND(BodyType=6,RETADD=2,RETOPT>=2)),Hgt+0.14,IF(AND(BodyType=7,RETOPT=1),Hgt,IF(AND(BodyType=7,RETOPT>=2),Hgt,\"\"))))))","v":""}]
[]
[null,"Frame Support Tube",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,"Length(s)",null,{"$f":"((HFST/12)/24)","v":0},{"$f":"THFB*Wdt","v":0}," Horz. Frame Supports Tubes"]
[]
[null,"Qty.","Part #",null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length(s)",null,{"$f":"((VFST/12)/24)","v":0},{"$f":"TVFB*Hgt","v":0}," Vert. Frame Support Tubes"]
[null,{"$f":"IF(KQ=0,\"\",IF(FST=1,\"\",IF(RETTYPE<=2,\"\",IF(RETTYPE=6,\"\",IF(NOYES=2,\"\",IF(AND(BodyType<=2,FBTYP=2),\"\",IF(AND(BodyType<=3,FBTYP=4),\"\",IF(AND(BodyType=7,FBTYP>=1),\"\",IF(AND(RETTYPE>=3,BodyType<=3),ROUNDUP(FSTTL*KQ,0),IF(AND(RETTYPE>=3,BodyType=4),ROUNDUP(FSTTL*KQ*2,0),IF(AND(RETTYPE>=3,BodyType=5),ROUNDUP(FSTTL*KQ*2,0),IF(AND(RETTYPE>=3,BodyType>=6),ROUNDUP(FSTTL*KQ,0),\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(FST=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE<=2,\"\",IF(RETTYPE=6,\"\",IF(AND(BodyType<=3,FBTYP=4),\"\",IF(RETTYPE=7,\"\",IF(AND(BodyType=7,FBTYP>=1),\"\",IF(FBTYP=1,\" 2175\",IF(FBTYP=2,\"2175\",IF(FBTYP=3,\"2177\",IF(FBTYP=4,\"2177\",\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(FST=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE<=2,\"\",IF(RETTYPE=6,\"\",IF(RETTYPE=7,\"\",IF(AND(BodyType=7,FBTYP>=1),\"\",IF(AND(BodyType<=3,FBTYP=4),\" Retro Frame Brace Not For Use With Single Face Bodies\",IF(FBTYP=1,\" Frame Support Tube - 3/4'' x 1-5/8'' Rectangular Aluminum Tube - (24'-0'' Lengths)\",IF(FBTYP=2,\" Frame Support Tube - 3/4'' x 1-5/8'' Rectangular Aluminum Tube - (24'-0'' Lengths)\",IF(FBTYP=3,\" Small Frame Support Tube - 1'' x 1'' Square  Aluminum Tube - (24'-0'' Lengths)\",IF(FBTYP=4,\" Small Frame Support Tube - 1'' x 1'' Square Aluminum Tube - (24'-0'' Lengths)\"))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Length(s)",null,{"$f":"THFST+TVFST","v":0}]
[]
[null,"Divider",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Divider Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AND(RETTYPE=1,DTYP=2),\"\",IF(AND(RETTYPE>=2,DTYP=1),\"\",IF(DTYP=1,\"2133\",IF(DTYP=2,\"2138\",IF(DTYP=3,\"2128\",IF(DTYP=4,\"2142\",\"\"))))))","v":"2133"},{"$f":"IF(AND(RETTYPE=1,DTYP=2),\"\",IF(AND(RETTYPE>=2,DTYP=1),\"\",IF(DTYP=1,\" 1-1/2'' Divider - Straight Cut Both Ends\",IF(DTYP=2,\" 2'' Divider - Straight Cut Both Ends\",IF(DTYP=3,\" 2-3/4'' Divider - Straight Cut Both Ends\",IF(DTYP=4,\" Dual Divider - Straight Cut Both Ends\",\"\"))))))","v":" 1-1/2'' Divider - Straight Cut Both Ends"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false]
[null,null,null,null,0,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(HD=TRUE,\" Insert Number of Horizontal Divider(s)\",\"\")))))","v":""},null,null,null,null,null,null,null,null,0,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(VD=TRUE,\" Insert Number of Vertical Divider(s)\",\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Select 2'' Divider or 2-3/4'' Divider"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\" Select Dual Divider and Dual Divider Cover\"","v":" Select Dual Divider and Dual Divider Cover"}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(RETOPT=1,RETTYPE=1),\"\",IF(AND(RETOPT=1,RETTYPE=2),\"\",IF(AND(RETTYPE=1,DTYP>=2),\"\",IF(AND(RETTYPE>=2,DTYP=1),\"\",IF(AND(RETTYPE=1,DTYP=4),\"\",IF(RETTYPE>=4,\"\",IF(AND(RETTYPE=2,RETOPT=1),\"\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\"\",IF(AND(BodyType<=3,HD=TRUE),KQ*NHD,IF(AND(BodyType=4,HD=TRUE),KQ*NHD*2,IF(AND(BodyType=5,HD=TRUE),KQ*NHD*2,IF(AND(BodyType=6,HD=TRUE),KQ*NHD,IF(AND(BodyType=7,HD=TRUE),KQ*NHD,\"\")))))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(RETOPT=1,RETTYPE=1),\"\",IF(AND(RETOPT=1,RETTYPE=2),\"\",IF(AND(RETTYPE=1,DTYP>=2),\"\",IF(AND(RETTYPE>=2,DTYP=1),\"\",IF(AND(RETTYPE=1,DTYP=4),\"\",IF(RETTYPE>=4,\"\",IF(AND(RETTYPE=2,RETOPT=1),\"\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\"\",IF(AND(AND(AND(BodyType=6,RETADD=1,RETTYPE=1,HD=TRUE))),(Wdt+0.265)-3,IF(AND(AND(AND(BodyType=6,RETADD=2,RETTYPE=1,HD=TRUE))),(Wdt+0.14)-3,IF(AND(AND(AND(BodyType=6,RETADD=1,RETTYPE>=2,HD=TRUE))),(Wdt+0.265)-4.5,IF(AND(AND(AND(BodyType=6,RETADD=2,RETTYPE>=2,HD=TRUE))),(Wdt+0.14)-4.5,IF(AND(RETTYPE=1,HD=TRUE),Wdt-3,IF(AND(RETTYPE=2,HD=TRUE),Wdt-4.5,IF(AND(RETTYPE=3,HD=TRUE),Wdt-4.5,\"\")))))))))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(RETOPT=1,RETTYPE=1),\"\",IF(AND(RETOPT=1,RETTYPE=2),\"\",IF(AND(RETTYPE=1,DTYP>=2),\"\",IF(AND(RETTYPE=1,DTYP=4),\"\",IF(RETTYPE>=4,\"\",IF(AND(RETTYPE=2,RETOPT=1),\"\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\"\",IF(AND(RETTYPE=1,HD=TRUE),DIVDR&PPTD,IF(AND(AND(RETTYPE=2,HD=TRUE,DTYP=4)),DIVDR,IF(AND(RETTYPE=2,HD=TRUE),DIVDR&PPTD,IF(AND(RETTYPE=3,HD=TRUE),DIVDR,\"\")))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(RETTYPE=1,DTYP>=2),\" Select 1-1/2'' Divider\",IF(AND(RETTYPE=2,DTYP=1),\" Select 2'' Divider or 2-3/4'' Divider or Dual Divider and Dual Divder Cover\",IF(AND(AND(RETTYPE=1,RETOPT<=2,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(RETTYPE=1,RETOPT=1),\" Select either One End or Both Ends Removable\",IF(AND(AND(RETTYPE=2,RETOPT=1,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(RETTYPE=2,RETOPT=1),\" Select either One End or Both Ends Removable\",IF(AND(RETTYPE=3,DTYP<=3),\" Select Dual Divider and Dual Divider Cover\",IF(RETTYPE>=4,\" Dividers do not work with Tension Frame, Bleed Rigid Retainer or 1-1/2'' Retainer\",IF(AND(RETTYPE=1,HD=TRUE),DDIS,IF(AND(RETTYPE=2,HD=TRUE),DDIS,IF(AND(RETTYPE=3,HD=TRUE),DDIS,\"\"))))))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\" Select 1-1/2'' Divider\"","v":" Select 1-1/2'' Divider"}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(DTYP<=3,\"\",IF(RETTYPE=1,\"\",IF(AND(RETOPT=1,RETTYPE=1),\"\",IF(AND(RETOPT=1,RETTYPE=2),\"\",IF(AND(RETTYPE>=2,DTYP=1),\"\",IF(RETTYPE>=4,\"\",IF(AND(RETTYPE=2,RETOPT=1),\"\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\"\",IF(AND(BodyType<=3,HD=TRUE),KQ*NHD,IF(AND(BodyType=4,HD=TRUE),KQ*NHD*2,IF(AND(BodyType=5,HD=TRUE),KQ*NHD*2,IF(AND(BodyType=6,HD=TRUE),KQ*NHD,IF(AND(BodyType=7,HD=TRUE),KQ*NHD,\"\")))))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(DTYP<=3,\"\",IF(AND(RETOPT=1,RETTYPE=1),\"\",IF(AND(RETOPT=1,RETTYPE=2),\"\",IF(AND(RETTYPE>=2,DTYP=1),\"\",IF(RETTYPE>=4,\"\",IF(AND(RETTYPE=2,RETOPT=1),\"\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\"\",IF(AND(AND(BodyType=6,RETADD=1,DTYP=4,OR(RETTYPE=2,RETTYPE=3))),(Wdt+0.265)-4.5,IF(AND(AND(BodyType=6,RETADD=2,DTYP=4,OR(RETTYPE=2,RETTYPE=3))),(Wdt+0.14)-4.5,IF(AND(AND(RETTYPE=2,HD=TRUE,DTYP=4)),Wdt-4.5,IF(AND(RETTYPE=2,HD=TRUE),Wdt-4.5,IF(AND(RETTYPE=3,HD=TRUE),Wdt-4.5,\"\"))))))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(DTYP<=3,\"\",IF(AND(RETOPT=1,RETTYPE=1),\"\",IF(AND(RETOPT=1,RETTYPE=2),\"\",IF(RETTYPE>=4,\"\",IF(AND(RETTYPE=2,RETOPT=1),\"\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\"\",IF(AND(AND(RETTYPE=2,HD=TRUE,DTYP=4)),DDCVN,IF(AND(RETTYPE=2,HD=TRUE),DDCVN,IF(AND(RETTYPE=3,HD=TRUE),DDCVN,\"\")))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(DTYP<=3,\"\",IF(AND(RETOPT=1,RETTYPE=1),\"\",IF(AND(RETOPT=1,RETTYPE=2),\"\",IF(RETTYPE>=4,\"\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=2,HD=TRUE,DTYP=4)),DDCVD,IF(AND(RETTYPE=2,HD=TRUE),DDCVD,IF(AND(RETTYPE=3,HD=TRUE),DDCVD,\"\"))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(RETTYPE=1,DTYP=2),\"\",IF(AND(RETTYPE>=2,DTYP=1),\"\",IF(DTYP=4,\"2146\"&PPTD,\"\")))","v":""},{"$f":"IF(AND(RETTYPE=1,DTYP=2),\"\",IF(AND(RETTYPE>=2,DTYP=1),\"\",IF(DTYP=4,\" Dual Divider Cover- Straight Cut Both Ends\",\"\")))","v":""},null,null,null,{"$f":"\" Select 2'' Divider or 2-3/4'' Divider or Dual Divider and Dual Divder Cover\"","v":" Select 2'' Divider or 2-3/4'' Divider or Dual Divider and Dual Divder Cover"}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(RETOPT=1,RETTYPE=1),\"\",IF(AND(RETOPT=1,RETTYPE=2),\"\",IF(AND(RETTYPE=1,DTYP>=2),\"\",IF(AND(RETTYPE>=2,DTYP=1),\"\",IF(AND(RETTYPE=1,DTYP=4),\"\",IF(RETTYPE>=4,\"\",IF(AND(RETTYPE=2,RETOPT<=2),\"\",IF(AND(BodyType<=3,VD=TRUE),KQ*NVD,IF(AND(BodyType=4,VD=TRUE),KQ*NVD*2,IF(AND(BodyType=5,VD=TRUE),KQ*NVD*2,IF(AND(BodyType=6,VD=TRUE),KQ*NVD,IF(AND(BodyType=7,VD=TRUE),KQ*NVD,\"\"))))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(RETOPT=1,RETTYPE=1),\"\",IF(AND(RETOPT=1,RETTYPE=2),\"\",IF(AND(RETTYPE=1,DTYP>=2),\"\",IF(AND(RETTYPE>=2,DTYP=1),\"\",IF(AND(RETTYPE=1,DTYP=4),\"\",IF(RETTYPE>=4,\"\",IF(AND(RETTYPE=2,RETOPT<=2),\"\",IF(AND(AND(AND(BodyType=6,RETADD=1,RETTYPE=1,VD=TRUE))),(Hgt+0.265)-3,IF(AND(AND(AND(BodyType=6,RETADD=2,RETTYPE=1,VD=TRUE))),(Hgt+0.14)-3,IF(AND(AND(AND(BodyType=6,RETADD=1,RETTYPE>=2,VD=TRUE))),(Hgt+0.265)-4.5,IF(AND(AND(AND(BodyType=6,RETADD=2,RETTYPE>=2,VD=TRUE))),(Hgt+0.14)-4.5,IF(AND(RETTYPE=1,VD=TRUE),Hgt-3,IF(AND(RETTYPE=2,VD=TRUE),Hgt-4.5,IF(AND(RETTYPE=3,VD=TRUE),Hgt-4.5,\"\"))))))))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(RETOPT=1,RETTYPE=1),\"\",IF(AND(RETOPT=1,RETTYPE=2),\"\",IF(AND(RETTYPE=1,DTYP>=2),\"\",IF(AND(RETTYPE=1,DTYP=4),\"\",IF(RETTYPE>=4,\"\",IF(AND(RETTYPE=2,RETOPT<=2),\"\",IF(AND(RETTYPE=1,VD=TRUE),DIVDR&PPTD,IF(AND(AND(RETTYPE=2,VD=TRUE,DTYP=4)),DIVDR,IF(AND(RETTYPE=2,VD=TRUE),DIVDR&PPTD,IF(AND(RETTYPE=3,VD=TRUE),DIVDR,\"\"))))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(RETTYPE=1,DTYP>=2),\" Select 1-1/2'' Divider\",IF(AND(RETTYPE=2,DTYP=1),\" Select 2'' Divider or 2-3/4'' Divider or Dual Divider and Dual Divder Cover\",IF(AND(AND(RETTYPE=1,RETOPT=1,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=1,RETOPT=2,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=2,RETOPT=1,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(RETTYPE=3,DTYP<=3),\" Select Dual Divider and Dual Divider Cover\",IF(RETTYPE>=4,\" Dividers do not work with Tension Frame, Bleed Rigid Retainer or 1-1/2'' Retainer\",IF(AND(RETTYPE=1,VD=TRUE),DDIS,IF(AND(RETTYPE=2,VD=TRUE),DDIS,IF(AND(RETTYPE=3,VD=TRUE),DDIS,\"\")))))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\" Dividers do not work with Tension Frame, Bleed Rigid Retainer or 1-1/2'' Retainer\"","v":" Dividers do not work with Tension Frame, Bleed Rigid Retainer or 1-1/2'' Retainer"}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(DTYP<=3,\"\",IF(RETTYPE=1,\"\",IF(AND(RETOPT=1,RETTYPE=1),\"\",IF(AND(RETOPT=1,RETTYPE=2),\"\",IF(RETTYPE>=4,\"\",IF(AND(RETTYPE=2,RETOPT=1),\"\",IF(AND(BodyType<=3,VD=TRUE),KQ*NVD,IF(AND(BodyType=4,VD=TRUE),KQ*NVD*2,IF(AND(BodyType=5,VD=TRUE),KQ*NVD*2,IF(AND(BodyType=6,VD=TRUE),KQ*NVD,IF(AND(BodyType=7,VD=TRUE),KQ*NVD,\"\")))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(DTYP<=3,\"\",IF(AND(RETOPT=1,RETTYPE=1),\"\",IF(AND(RETOPT=1,RETTYPE=2),\"\",IF(AND(RETTYPE>=2,DTYP=1),\"\",IF(RETTYPE>=4,\"\",IF(AND(RETTYPE=2,RETOPT=1),\"\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\"\",IF(AND(AND(BodyType=6,RETADD=1,DTYP=4,OR(RETTYPE=2,RETTYPE=3))),(Hgt+0.265)-4.5,IF(AND(AND(BodyType=6,RETADD=2,DTYP=4,OR(RETTYPE=2,RETTYPE=3))),(Hgt+0.14)-4.5,IF(AND(AND(RETTYPE=2,VD=TRUE,DTYP=4)),Hgt-4.5,IF(AND(RETTYPE=2,VD=TRUE),Hgt-4.5,IF(AND(RETTYPE=3,VD=TRUE),Hgt-4.5,\"\"))))))))))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(DTYP<=3,\"\",IF(AND(RETOPT=1,RETTYPE=1),\"\",IF(AND(RETOPT=1,RETTYPE=2),\"\",IF(RETTYPE>=4,\"\",IF(AND(RETTYPE=2,RETOPT=1),\"\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\"\",IF(AND(RETTYPE=2,VD=TRUE),DDCVN,IF(AND(RETTYPE=3,VD=TRUE),DDCVN,\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(DTYP<=3,\"\",IF(AND(RETOPT=1,RETTYPE=1),\"\",IF(AND(RETOPT=1,RETTYPE=2),\"\",IF(RETTYPE>=4,\"\",IF(AND(RETTYPE=2,RETOPT=1),\"\",IF(AND(AND(RETTYPE=2,RETOPT=2,VD=TRUE)),\" Select Both Ends Removable\",IF(AND(AND(RETTYPE=2,VD=TRUE,DTYP=4)),DDCVD,IF(AND(RETTYPE=2,VD=TRUE),DDCVD,IF(AND(RETTYPE=3,VD=TRUE),DDCVD,\"\")))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\" Select either One End or Both Ends Removable\"","v":" Select either One End or Both Ends Removable"}]
[]
[null,"Vandal Cover",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null," Retro Frame Brace Not For Use With Single Face Bodies"]
[]
[null,"Inner Frame",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(BodyType<=3,KQ*2,IF(AND(BodyType>=4,BodyType<=5),KQ*4,IF(BodyType>=6,KQ*2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(BodyType<=5,Wdt,IF(AND(BodyType=6,RETADD=1),Wdt+0.265,IF(AND(BodyType=6,RETADD=2),Wdt+0.14,IF(BodyType=7,Wdt,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(INFRM=1,\"2099\"&PPTD,IF(INFRM=2,\"2097\"&PPTD,\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(INFRM=1,\" Inner Frame Retainer - Top & Bottom - Mitered both ends\",IF(INFRM=2,\" Large Inner Frame Retainer - Top & Bottom - Mitered both ends\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(BodyType<=3,KQ*2,IF(AND(BodyType>=4,BodyType<=5),KQ*4,IF(BodyType>=6,KQ*2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(BodyType<=5,Hgt,IF(AND(BodyType=6,RETADD=1),Hgt+0.265,IF(AND(BodyType=6,RETADD=2),Hgt+0.14,IF(BodyType=7,Hgt,\"\"))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(INFRM=1,\"2099\"&PPTD,IF(INFRM=2,\"2097\"&PPTD,\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(INFRM=1,\" Inner Frame Retainer - Both Ends - Mitered both ends\",IF(INFRM=2,\" Large Inner Frame Retainer - Both Ends - Mitered both ends\",\"\"))))","v":""}]
[]
[null,"Outer Frame",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"##\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(BodyType<=3,KQ*2,IF(AND(BodyType>=4,BodyType<=5),KQ*4,IF(BodyType>=6,KQ*2,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"####\",IF(AND(INFRM=2,OTFRM=1),\"####\",IF(AND(OTFRM=1,Hinge=1),IFW-0.875,IF(AND(OTFRM=2,Hinge=1),IFW-1.243,IF(AND(OTFRM=1,Hinge=2),IFW-1.125,IF(AND(OTFRM=2,Hinge=2),IFW-1.228))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"####\",IF(AND(INFRM=2,OTFRM=1),\"####\",IF(OTFRM=1,\"1942\"&PPTD,IF(OTFRM=2,\"1941\"&PPTD))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\" Select 2Part Outer Frame\",IF(AND(INFRM=2,OTFRM=1),\" Select 2Part Large Outer Frame\",IF(OTFRM=1,\" 2Part Outer Frame - Top/Bottom - Mitered both ends\",IF(OTFRM=2,\" 2Part Large Outer Frame - Top/Bottom - Mitered both ends\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\" Select 2Part Large Outer Frame\"","v":" Select 2Part Large Outer Frame"}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"##\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(BodyType<=3,KQ*2,IF(AND(BodyType>=4,BodyType<=5),KQ*4,IF(BodyType>=6,KQ*2,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"####\",IF(AND(INFRM=2,OTFRM=1),\"####\",IF(AND(OTFRM=1,Hinge=1),IFH-1.125,IF(AND(OTFRM=2,Hinge=1),IFH-1.228,IF(AND(OTFRM=1,Hinge=2),IFH-0.875,IF(AND(OTFRM=2,Hinge=2),IFH-1.243))))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"####\",IF(AND(INFRM=2,OTFRM=1),\"####\",IF(OTFRM=1,\"1942\"&PPTD,IF(OTFRM=2,\"1941\"&PPTD))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\" Select 2Part Outer Frame\",IF(AND(INFRM=2,OTFRM=1),\" Select 2Part Large Outer Frame\",IF(OTFRM=1,\" 2Part Outer Frame - Sides -  Mitered both ends\",IF(OTFRM=2,\" 2Part Large Outer Frame -  Sides - Mitered both ends\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\" Select 2Part Outer Frame\"","v":" Select 2Part Outer Frame"}]
[null,"Hinge"]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"##\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(BodyType<=3,KQ*1,IF(AND(BodyType>=4,BodyType<=5),KQ*2,IF(BodyType>=6,KQ*1,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"####\",IF(AND(INFRM=2,OTFRM=1),\"####\",IF(Hinge=1,OFH,IF(Hinge=2,OFW))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"####\",IF(AND(INFRM=2,OTFRM=1),\"####\",IF(OTFRM=1,\"5996\"&PPTD,IF(OTFRM=2,\"5997\"&PPTD))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\" Select 2Part Outer Frame\",IF(AND(INFRM=2,OTFRM=1),\" Select 2Part Large Outer Frame\",IF(AND(OTFRM=1,Hinge=1),\" 2Part Hinge - Top or Bottom Hinged - 1-1/16'' x .90'' Aluminum Hinge\",IF(AND(OTFRM=2,Hinge=1),\" 2Part Large Hinge - Top or Bottom Hinged - 1-1/16'' x .090'' Aluminum Hinge\",IF(AND(OTFRM=1,Hinge=2),\" 2Part Hinge - Side Hinged - 1-1/2'' x .090'' Aluminum Hinge\",IF(AND(OTFRM=2,Hinge=2),\" 2Part Large Hinge - Side Hinged - 1-1/2'' x .090'' Aluminum Hinge\"))))))))","v":""}]
[]
[]
[]
[]
[]
[null,"BILL OF MATERIAL"]
[null,{"$f":"DIS","v":""}]
[]
[null,"Customer  ",null,null,null,{"$f":"IF(Cust=0,\"\",Cust)","v":""},null,null,null,null,null,null,null,null,"Order#   ",null,null,null,{"$f":"IF(Ordnum=0,\"\",Ordnum)","v":""}]
[null,"Kit Quantity  ",null,null,null,{"$f":"IF(KQ=0,\"\",KQ)","v":""},null,"Height  ",null,null,null,{"$f":"IF(KQ=0,\"\",Hgt)","v":""},null,"Width",null,null,null,{"$f":"IF(KQ=0,\"\",Wdt)","v":""}]
[]
[null,"Hardware"]
[null,"Retainer"]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(BodyType<=3,RETTYPE<=4),KQ*4,IF(AND(BodyType<=3,RETTYPE=5),KQ*8,IF(AND(BodyType=4,RETTYPE<=4),KQ*8,IF(AND(BodyType=4,RETTYPE=5),KQ*16,IF(AND(BodyType=5,RETTYPE<=4),KQ*8,IF(AND(BodyType=5,RETTYPE=5),KQ*16,IF(AND(BodyType=6,RETTYPE<=4),KQ*4,IF(AND(BodyType=6,RETTYPE=5),KQ*8,IF(AND(BodyType=7,RETTYPE<=4),KQ*4,IF(AND(BodyType=7,RETTYPE=5),KQ*8,IF(AND(RETTYPE=6,BodyType<=3),KQ*4,IF(AND(RETTYPE=6,OR(BodyType=4,BodyType=5)),KQ*8,IF(AND(RETTYPE=6,BodyType>=6),KQ*4,IF(AND(BodyType<=3,RETTYPE=7),KQ*8,IF(AND(RETTYPE=7,OR(BodyType=4,BodyType=5)),KQ*16,IF(AND(BodyType>=6,RETTYPE=7),KQ*8,IF(AND(BodyType<=3,RETTYPE=8),KQ*4,IF(AND(RETTYPE=8,OR(BodyType=4,BodyType=5)),KQ*8,IF(AND(BodyType>=6,RETTYPE=8),KQ*4,IF(AND(BodyType<=3,RETTYPE=9),KQ*8,IF(AND(RETTYPE=9,OR(BodyType=4,BodyType=5)),KQ*16,IF(AND(BodyType>=6,RETTYPE=9),KQ*8,\"\")))))))))))))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(BodyType>=1,\"5210\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(BodyType<=3,RETTYPE<=4),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType<=3,RETTYPE=5),\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BodyType=4,RETTYPE<=4),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=4,RETTYPE=5),\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BodyType=5,RETTYPE<=4),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=5,RETTYPE=5),\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BodyType=6,RETTYPE<=4),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=6,RETTYPE=5),\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BodyType=7,RETTYPE<=4),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType=7,RETTYPE=5),\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(RETTYPE=6,BodyType<=3),\"Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(RETTYPE=6,OR(BodyType=4,BodyType=5)),\"Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(RETTYPE=6,BodyType>=6),\"Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType<=3,RETTYPE=7),\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(RETTYPE=7,OR(BodyType=4,BodyType=5)),\" Corner Key - .120 Stamped Aluminum - Four (4) per corner\",IF(AND(BodyType>=6,RETTYPE=7),\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BodyType<=3,RETTYPE=8),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(RETTYPE=8,OR(BodyType=4,BodyType=5)),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType>=6,RETTYPE=8),\" Corner Key - .120 Stamped Aluminum - One (1) per corner\",IF(AND(BodyType<=3,RETTYPE=9),\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(RETTYPE=9,OR(BodyType=4,BodyType=5)),\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\",IF(AND(BodyType>=6,RETTYPE=9),\" Corner Key - .120 Stamped Aluminum - Two (2) per corner\",\"\")))))))))))))))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=6,\"\",IF(RETTYPE=7,\"\",IF(AND(BodyType<=3,RETTYPE<=3),KQ*8,IF(AND(BodyType=4,RETTYPE<=3),KQ*16,IF(AND(BodyType=5,RETTYPE<=3),KQ*16,IF(AND(BodyType>=6,RETTYPE<=3),KQ*8,IF(AND(AND(BodyType<=3,RETTYPE>=4,RETTYPE<=5)),KQ*4,IF(AND(AND(BodyType=4,RETTYPE>=4,RETTYPE<=5)),KQ*8,IF(AND(AND(BodyType=5,RETTYPE>=4,RETTYPE<=5)),KQ*8,IF(AND(AND(BodyType>=6,RETTYPE>=4,RETTYPE<=5)),KQ*4,IF(AND(AND(BodyType<=3,RETTYPE>=8,RETTYPE<=9)),KQ*4,IF(AND(AND(BodyType=4,RETTYPE>=8,RETTYPE<=9)),KQ*8,IF(AND(AND(BodyType=5,RETTYPE>=8,RETTYPE<=9)),KQ*8,IF(AND(AND(BodyType>=6,RETTYPE>=8,RETTYPE<=9)),KQ*4,\"\")))))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=6,\"\",IF(RETTYPE=7,\"\",IF(RETTYPE=1,\"5304\",IF(RETTYPE=2,\"5305\",IF(RETTYPE=3,\"5305\",IF(RETTYPE=4,\"5305\",IF(RETTYPE=5,\"5305\",IF(RETTYPE=8,\"5305\",IF(RETTYPE=9,\"5305\",\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=6,\"\",IF(RETTYPE=7,\"\",IF(RETTYPE=1,\" Frame Corner Angle - 2'' x 2'' x 3/16'' (9/16'') - Two (2) Per Corner\",IF(AND(RETTYPE>=2,RETTYPE<=3),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (1-1/16'') - Two (2) per corner\",IF(RETTYPE>=4,\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (1-1/16'') - One (1) per corner\",\"\"))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(BodyType<=3,RETTYPE<=3),KQ*10,IF(AND(RETTYPE<=3,OR(BodyType=4,BodyType=5)),KQ*18,IF(AND(BodyType>=6,RETTYPE<=3),KQ*10,IF(AND(BodyType<=3,OR(RETTYPE=4,RETTYPE=5)),KQ*10,IF(AND(BodyType=4,OR(RETTYPE=4,RETTYPE=5)),KQ*18,IF(AND(BodyType=5,OR(RETTYPE=4,RETTYPE=5)),KQ*18,IF(AND(BodyType>=6,OR(RETTYPE=4,RETTYPE=5)),KQ*10,IF(AND(BodyType<=3,RETTYPE=6),KQ*18,IF(AND(RETTYPE=6,OR(BodyType=4,BodyType=5)),KQ*34,IF(AND(BodyType>=6,RETTYPE=6),KQ*18,IF(AND(BodyType<=3,RETTYPE=7),KQ*18,IF(AND(RETTYPE=7,OR(BodyType=4,BodyType=5)),KQ*34,IF(AND(BodyType>=6,RETTYPE=7),KQ*18,IF(AND(BodyType<=3,OR(RETTYPE=8,RETTYPE=9)),KQ*10,IF(AND(BodyType=4,OR(RETTYPE=8,RETTYPE=9)),KQ*18,IF(AND(BodyType=5,OR(RETTYPE=8,RETTYPE=9)),KQ*18,IF(AND(BodyType>=6,OR(RETTYPE=8,RETTYPE=9)),KQ*10,\"\"))))))))))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=1,\"5218\",IF(AND(RETTYPE>=2,RETTYPE<=5),\"5218\",IF(RETTYPE=6,\"5168\",IF(RETTYPE=7,\"5195\",IF(AND(RETTYPE>=8,RETTYPE<=9),\"5218\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=1,\" Frame Corner Angle Screw - #10 x 1/2'' Sq/Phillips S.S. Pan Head Tapping Screw - Type AB - Two (2) Per Corner\",IF(OR(RETTYPE=2,RETTYPE=3),\" Frame Corner Angle Screw - #10 x 1/2'' Sq/Phillips S.S. Pan Head Tapping Screw - Type AB - Two (2) per corner\",IF(OR(RETTYPE=4,RETTYPE=5),\" Frame Corner Angle Screw - #10 x 1/2'' Sq/Phillips S.S. Pan Head Tapping Screw - Type AB - Two (2) per corner\",IF(RETTYPE=6,\" Retainer Corner Key Screw - #8 x 1/2'' Sq/Phillips S.S. Countersink Screw - Type A - Four (4) per Corner\",IF(RETTYPE=7,\" 1-1/2'' Retainer Screw - #8 x 5/16'' Sq/Phillips S.S. Pan Head Screw - Type B - Four (4) per Corner\",IF(OR(RETTYPE=8,RETTYPE=9),\" Frame Corner Angle Screw - #8 x 3/8'' Sq/Phillips S.S. Pan Head Tapping Screw - Type B - Two (2) per corner\",\"\")))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(BodyType=4,FBTYP=4),\"\",IF(AND(BodyType=5,FBTYP=4),\"\",IF(BodyType<=3,((ROUNDDOWN(Wdt/36,0)+1)+2)*KQ,IF(AND(BodyType>=4,BodyType<=5),(((ROUNDDOWN(Wdt/36,0)+1)*2)+2)*KQ,IF(BodyType>=6,((ROUNDDOWN(Wdt/36,0)+1)+2)*KQ,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(BodyType=4,FBTYP=4),\"\",IF(AND(BodyType=5,FBTYP=4),\"\",IF(RETTYPE>=1,\"5170\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(BodyType=4,FBTYP=4),\"\",IF(AND(BodyType=5,FBTYP=4),\"\",IF(RETTYPE>=1,\" Hinge Screw - 1/4-20 x 1/2'' Allen Head S.S. Machine Screw - One (1) every 36'' on center\",\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(BodyType>=4,BodyType<=5),(((ROUNDDOWN(Wdt/36,0)+1)*2)*KQ))","v":false},{"$f":"HS+CS","v":3}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(BodyType=4,FBTYP=4),(HSCS*2)*KQ+2,IF(AND(BodyType=5,FBTYP=4),(HSCS*2)*KQ+2,IF(BodyType<=3,CS*KQ,IF(AND(BodyType>=4,BodyType<=5),CS*KQ*2,IF(BodyType>=6,CS*KQ,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE>=1,\"5180\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE>=1,\" Closure Screw - 1/4-20 x 3/4'' Sq/Phillips Pan Head S.S. Machine Screw - One (1) every 48'' on center\",\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF77+AG77+AH77","v":3},{"$f":"ROUNDDOWN((Hgt/48)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/48)+1,0)","v":1},{"$f":"ROUNDDOWN((Hgt/48)+1,0)","v":1}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE=7,\"\",IF(AND(RETTYPE<=2,RETOPT=1),\"\",IF(BodyType<=3,(CVRS+2)*KQ,IF(OR(BodyType=4,BodyType=5),((CVRS*2)+2)*KQ,IF(BodyType>=6,(CVRS+2)*KQ,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(RETTYPE=1,RETOPT=1),\"\",IF(AND(RETTYPE=2,RETOPT=1),\"\",IF(AND(RETTYPE>=1,RETTYPE<=5),\"5195\",IF(RETTYPE=6,\"5285\",IF(AND(RETTYPE>=8,RETTYPE<=9),\"5195\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(NOYES=2,\"\",IF(AND(RETTYPE=1,RETOPT=1),\"\",IF(AND(RETTYPE=2,RETOPT=1),\"\",IF(AND(RETTYPE>=1,RETTYPE<=5),\" Cover Screw - #8 x 5/16'' Steel Zinc Sq/Pillips Pan Head Screw - One (1) every 24'' on center\",IF(RETTYPE=6,\" Face Attachment Hardware - 1/4-20 x 1'' CS Machine Screw/Bushing /Nut - One (1) every 12'' on Center\",IF(AND(RETTYPE>=8,RETTYPE<=9),\" Cover Screw - #8 x 5/16'' Steel Zinc Sq/Pillips Pan Head Screw - One (1) every 24'' on center\",\"\"))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(AND(RETTYPE<=2,RETOPT=1),\"\",IF(AND(RETTYPE<=2,RETOPT=2),VertL,IF(AND(RETTYPE<=2,RETOPT=3),VertL+VertR,IF(RETTYPE>=3,VertL+HorzT+HorzB+VertR,\"\"))))))","v":""},{"$f":"IF(IF(RETTYPE=6,ROUNDUP((Hgt/12)+1,0),ROUNDDOWN((Hgt/24)+1,0))<2,2,IF(RETTYPE=6,ROUNDUP((Hgt/12)+1,0),ROUNDDOWN((Hgt/24)+1,0)))","v":2},{"$f":"IF(RETTYPE=6,ROUNDUP((Wdt/12)+1,0),ROUNDUP((Wdt/24)+1,0))","v":1},{"$f":"IF(RETTYPE=6,ROUNDUP((Wdt/12)+1,0),ROUNDUP((Wdt/24)+1,0))","v":1},{"$f":"IF(IF(RETTYPE=6,ROUNDUP((Hgt/12)+1,0),ROUNDDOWN((Hgt/24)+1,0))<2,2,IF(RETTYPE=6,ROUNDUP((Hgt/12)+1,0),ROUNDDOWN((Hgt/24)+1,0)))","v":2},null," Retro Frame Brace Not For Use With Single Face Bodies"]
[null,"Body"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType>=6,\"\",IF(BodyType<=5,KQ*4,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType>=6,\"\",IF(BodyType=1,\"5320\",IF(BodyType=2,\"5321\",IF(BodyType=3,\"5322\",IF(BodyType=4,\"5318\",IF(BodyType=5,\"5312\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType>=6,\"\",IF(BodyType=1,\" Slimline Single Face Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (7/8'') - One (1) per corner\",IF(BodyType=2,\" Narrow Single Face Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (2-5/16'') - One (1) per corner\",IF(BodyType=3,\" Single Face Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (5-9/16'') - One (1) per corner\",IF(BodyType=4,\" Medium Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (6-7/8'') - One (1) per corner\",IF(BodyType=5,\" Wide Body Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (10-1/16'') - One (1) per corner\",\"\"))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5300," Divider Corner Angle w/Notch - 1-3/4'' x 1-3/4'' x 1/4'' x 1-1/16'' Wide - Two (2) Placed every 36'' on Center"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType>=6,\"\",IF(BodyType<=5,KQ*18,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType>=6,\"\",IF(BodyType<=5,\"5218\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType>=6,\"\",IF(BodyType<=5,\" Corner Angle Screw - #10 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type AB - Four (4) per corner\",\"\"))))","v":""}]
[]
[null,"Frame Braces",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2," Not for use with fluorescent illumination",null,null,null," Call Customer Service for assistance"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(RETTYPE<=2,\"\",IF(OR(RETTYPE=6,RETTYPE=7),\"\",IF(AND(BodyType<=2,FBTYP=2),\"\",IF(AND(BodyType<=3,FBTYP=4),\"\",IF(AND(BodyType<=3,FBTYP=4),\"\",IF(AND(BodyType=1,OR(RETTYPE=8,RETTYPE=9)),KQ*FBT*2,IF(BodyType<=3,KQ*FBTT,IF(OR(BodyType=4,BodyType=5),KQ*FBTT*2,IF(BodyType=6,KQ*FBTT,IF(AND(AND(BodyType=7,FBTYP>=1,RETTYPE>=4)),KQ*FBTT,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(RETTYPE<=2,\"\",IF(RETTYPE=6,\"\",IF(RETTYPE=7,\"\",IF(AND(BodyType<=3,FBTYP=4),\"\",IF(AND(BodyType=7,FBTYP>=1),\"\",IF(AND(BodyType=1,RETTYPE>=8),\"5300\",IF(FBTYP=1,\"5350\",IF(FBTYP=2,\"5357\",IF(FBTYP=3,\"5352\",IF(FBTYP=4,\"5354\",\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(RETTYPE<=2,\"\",IF(RETTYPE=6,\"\",IF(RETTYPE=7,\"\",IF(AND(BodyType=7,FBTYP>=1),\"\",IF(AND(BodyType=1,RETTYPE>=8),\" Divider Corner Angle w/Notch - 1-3/4'' x 1-3/4'' x 1/4'' x 1-1/16'' Wide - Two (2) Placed every 36'' on Center\",IF(AND(BodyType<=3,FBTYP=4),\" Retro Frame Brace Not For Use With Single Face Bodies\",IF(FBTYP=1,\" Frame Brace - 1-3/8'' wide - Placed Approx. 36'' on Center\",IF(FBTYP=2,\" 2 Piece Frame Brace - 1'' wide - Placed Approx. 36'' on Center\",IF(FBTYP=3,\" Small Frame Brace - 1-1/8'' wide - Placed Approx. 36'' on Center\",IF(FBTYP=4,\" Retro Frame Brace - 1-1/8'' wide - Placed Approx. 36'' on Center\"))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(RETTYPE>=3,FBTYP=1),FBT,IF(AND(RETTYPE>=3,FBTYP=2),FBT,IF(AND(RETTYPE>=3,FBTYP=3),FBT,IF(AND(RETTYPE>=3,FBTYP=4),FBT,\"\"))))","v":""}]
[null,"Tension Clips",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",AF86+AG86+AH86+AI86+AJ86+AK86))","v":""},{"$f":"ROUNDDOWN((Hgt/6)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/6)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/6)+1,0)","v":1},{"$f":"ROUNDDOWN((Hgt/6)+1,0)","v":1},{"$f":"IF(DTYP<=3,\"0\",IF(AND(DTYP=4,HD=FALSE),\"0\",IF(AND(DTYP=4,HD=TRUE),ROUNDUP((Wdt/6)+1,0)*2*NHD,\"\")))","v":"0"},{"$f":"IF(DTYP<=3,\"0\",IF(AND(DTYP=4,VD=FALSE),\"0\",IF(AND(DTYP=4,VD=TRUE),ROUNDUP((Hgt/6)+1,0)*2*NVD,\"\")))","v":"0"}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(RETTYPE<=2,\"\",IF(RETTYPE=6,\"\",IF(RETTYPE=7,\"\",IF(AND(BodyType<=3,RETTYPE=3),KQ*DFTC,IF(AND(BodyType=4,RETTYPE=3),KQ*DFTC*2,IF(AND(BodyType=5,RETTYPE=3),KQ*DFTC*2,IF(AND(BodyType>=6,RETTYPE=3),KQ*DFTC,IF(AND(BodyType<=3,RETTYPE>=4),KQ*TFTC,IF(AND(BodyType=4,RETTYPE>=4),KQ*TFTC*2,IF(AND(BodyType=5,RETTYPE>=4),KQ*TFTC*2,IF(AND(BodyType>=6,RETTYPE>=4),KQ*TFTC,\"\")))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(RETTYPE<=2,\"\",IF(RETTYPE=6,\"\",IF(RETTYPE=7,\"\",IF(RETTYPE>=3,\"5360\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(RETTYPE<=2,\"\",IF(RETTYPE=6,\"\",IF(RETTYPE=7,\"\",IF(RETTYPE=3,\" Tension Clip - One (1) Tension Clip every 6'' on center (See Tensioning Instruction for additional placement information)\",IF(RETTYPE>=4,\" Tension Clip - One (1) Tension Clip every 5'' on center (See Tensioning Instruction for additional placement information)\",\"\")))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",AF87+AG87+AH87+AI87))","v":""},{"$f":"ROUNDDOWN((Hgt/5)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/5)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/5)+1,0)","v":1},{"$f":"ROUNDDOWN((Hgt/5)+1,0)","v":1}]
[null,"Divider"]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(RETTYPE=1,HD=TRUE),DHEA,IF(AND(RETTYPE=2,HD=TRUE),DHEA,IF(AND(RETTYPE=3,HD=TRUE),DHEA,IF(AND(RETTYPE>=4,HD=TRUE),\"\",\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(RETTYPE=1,HD=TRUE),\"5301\",IF(AND(RETTYPE=2,HD=TRUE),\"5300\",IF(AND(RETTYPE=3,HD=TRUE),\"5300\",IF(AND(RETTYPE>=4,HD=TRUE),\"\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(RETTYPE=1,HD=TRUE),\" 1-1/2'' Divider Angle - Two (2) Per End - ( Horizontal Divider/s )\",IF(AND(RETTYPE=2,HD=TRUE),\" Divider Angle - Two (2) Per End - (Horizontal Divider/s )\",IF(AND(RETTYPE=3,HD=TRUE),\" Divider Angle - Two (2) Per End - ( Horizontal Divider/s )\",IF(AND(RETTYPE>=4,HD=TRUE),\"\",\"\"))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(BodyType<=3,HD=TRUE),KQ*NHD*2*2,IF(AND(BodyType=4,HD=TRUE),KQ*NHD*4*2,IF(AND(BodyType=5,HD=TRUE),KQ*NHD*4*2,IF(AND(BodyType>=6,HD=TRUE),KQ*NHD*4,\"\"))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(RETTYPE=1,VD=TRUE),DVEA,IF(AND(RETTYPE=2,VD=TRUE),DVEA,IF(AND(RETTYPE=3,VD=TRUE),DVEA,IF(AND(RETTYPE>=4,VD=TRUE),\"\",\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(RETTYPE=1,VD=TRUE),\"5301\",IF(AND(RETTYPE=2,VD=TRUE),\"5300\",IF(AND(RETTYPE=3,VD=TRUE),\"5300\",IF(AND(RETTYPE>=4,VD=TRUE),\"\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(RETTYPE=1,VD=TRUE),\" 1-1/2'' Divider Angle - Two (2) Per End - ( Vertical Divider/s )\",IF(AND(RETTYPE=2,VD=TRUE),\" Divider Angle - Two (2) Per End - ( Vertical Divider/s )\",IF(AND(RETTYPE=3,VD=TRUE),\" Divider Angle - Two (2) Per End - ( Vertical Divider/s )\",IF(AND(RETTYPE>=4,VD=TRUE),\"\",\"\"))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(BodyType<=3,VD=TRUE),KQ*NVD*2*2,IF(AND(BodyType=4,VD=TRUE),KQ*NVD*4*2,IF(AND(BodyType=5,VD=TRUE),KQ*NVD*4*2,IF(AND(BodyType>=6,VD=TRUE),KQ*NVD*2*2,\"\"))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(RETTYPE=1,HD=TRUE),HDAS+2,IF(AND(RETTYPE=2,HD=TRUE),HDAS+2,IF(AND(RETTYPE=3,HD=TRUE),HDAS+2,IF(AND(RETTYPE>=4,HD=TRUE),\"\",\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(RETTYPE=1,HD=TRUE),\"5218\",IF(AND(RETTYPE=2,HD=TRUE),\"5218\",IF(AND(RETTYPE=3,HD=TRUE),\"5218\",IF(AND(RETTYPE>=4,HD=TRUE),\"\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(RETTYPE=1,HD=TRUE),\" Divider Screw - #10 x 1/2'' Sq/Phillips Pan Head Screw - Two (2) Per End - ( Horizontal Divider/s )\",IF(AND(RETTYPE=2,HD=TRUE),\" Divider Screw - #10 x 1/2'' Sq/Phillips Pan Head Screw - Two (2) Per End - (Horizontal Divider/s )\",IF(AND(RETTYPE=3,HD=TRUE),\" Divider Screw - #10 x 1/2'' Sq/Phillips Pan Head Screw - Two (2) Per End - ( Horizontal Divider/s )\",IF(AND(RETTYPE>=4,HD=TRUE),\"\",\"\"))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(BodyType<=3,HD=TRUE),KQ*NHD*4,IF(AND(BodyType=4,HD=TRUE),KQ*NHD*4*2,IF(AND(BodyType=5,HD=TRUE),KQ*NHD*4*2,IF(AND(BodyType>=6,HD=TRUE),KQ*NHD*4,\"\"))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(RETTYPE=1,VD=TRUE),VDAS+2,IF(AND(RETTYPE=2,VD=TRUE),VDAS+2,IF(AND(RETTYPE=3,VD=TRUE),VDAS+2,IF(AND(RETTYPE>=4,VD=TRUE),\"\",\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(RETTYPE=1,VD=TRUE),\"5218\",IF(AND(RETTYPE=2,VD=TRUE),\"5218\",IF(AND(RETTYPE=3,VD=TRUE),\"5218\",IF(AND(RETTYPE>=4,VD=TRUE),\"\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(RETTYPE=1,VD=TRUE),\" Divider Screw - #10 x 1/2'' Sq/Phillips Pan Head Screw - Two (2) Per End - ( Vertical Divider/s )\",IF(AND(RETTYPE=2,VD=TRUE),\" Divider Screw - #10 x 1/2'' Sq/Phillips Pan Head Screw - Two (2) Per End - (Vertical Divider/s )\",IF(AND(RETTYPE=3,VD=TRUE),\" Divider Screw - #10 x 1/2'' Sq/Phillips Pan Head Screw - Two (2) Per End - ( Vertical Divider/s )\",IF(AND(RETTYPE>=4,VD=TRUE),\"\",\"\"))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(BodyType<=3,VD=TRUE),KQ*NVD*4,IF(AND(BodyType=4,VD=TRUE),KQ*NVD*4*2,IF(AND(BodyType=5,VD=TRUE),KQ*NVD*4*2,IF(AND(BodyType>=6,VD=TRUE),KQ*NVD*4,\"\"))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(AND(RETTYPE=1,VD=TRUE,HD=TRUE)),DVJT,IF(AND(AND(RETTYPE=2,VD=TRUE,HD=TRUE)),DVJT,IF(AND(AND(RETTYPE=3,VD=TRUE,HD=TRUE)),DVJT,IF(AND(AND(RETTYPE>=4,VD=TRUE,HD=TRUE)),\"\",\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(OR(HD=FALSE,VD=FALSE),\"\",IF(AND(RETTYPE=1,HD=TRUE),\"5301\",IF(AND(RETTYPE=2,HD=TRUE),\"5300\",IF(AND(RETTYPE=3,HD=TRUE),\"5300\",IF(AND(RETTYPE>=4,HD=TRUE),\"\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(OR(HD=FALSE,VD=FALSE),\"\",IF(AND(RETTYPE=1,HD=TRUE),\" 1-1/2'' Divider Angle - Four (4) Per Joint \",IF(AND(RETTYPE=2,HD=TRUE),\" Divider Angle - Four (4) Per Joint \",IF(AND(RETTYPE=3,HD=TRUE),\" Divider Angle - Four (4) Per Joint \",IF(AND(RETTYPE>=4,HD=TRUE),\"\",\"\"))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(OR(HD=FALSE,VD=FALSE),\"\",IF(AND(BodyType<=3,HD=TRUE),KQ*DVJ*4,IF(AND(BodyType=4,HD=TRUE),KQ*DVJ*4*2,IF(AND(BodyType=5,HD=TRUE),KQ*DVJ*4*2,IF(AND(BodyType>=6,HD=TRUE),KQ*DVJ*4,\"\"))))))))","v":""},{"$f":"NHD*NVD","v":0}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(RETTYPE=1,VD=TRUE),DJST+2,IF(AND(RETTYPE=2,VD=TRUE),DJST+2,IF(AND(RETTYPE=3,VD=TRUE),DJST+2,IF(AND(RETTYPE>=4,VD=TRUE),\"\",\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(OR(HD=FALSE,VD=FALSE),\"\",IF(AND(RETTYPE=1,HD=TRUE),\"5218\",IF(AND(RETTYPE=2,HD=TRUE),\"5218\",IF(AND(RETTYPE=3,HD=TRUE),\"5218\",IF(AND(RETTYPE>=4,HD=TRUE),\"\",\"\"))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(OR(HD=FALSE,VD=FALSE),\"\",IF(AND(RETTYPE=1,HD=TRUE),\" 1-1/2'' Divider Angle Screw - #10 x 1/2'' Sq/Phillips Pan Head - Four (4) Per Joint \",IF(AND(RETTYPE=2,HD=TRUE),\" Divider Angle Screw - #10 x 1/2'' Sq/Phillips Pan Head - Four (4) Per Joint \",IF(AND(RETTYPE=3,HD=TRUE),\" Divider Angle Screw - #10 x 1/2'' Sq/Phillips Pan Head - Four (4) Per Joint \",IF(AND(RETTYPE>=4,HD=TRUE),\"\",\"\"))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=2,\"\",IF(NoYes2=1,\"\",IF(OR(HD=FALSE,VD=FALSE),\"\",IF(AND(BodyType<=3,HD=TRUE),KQ*DJS*4,IF(AND(BodyType=4,HD=TRUE),KQ*DJS*4*2,IF(AND(BodyType=5,HD=TRUE),KQ*DJS*4*2,IF(AND(BodyType>=6,HD=TRUE),KQ*DJS*4,\"\"))))))))","v":""},{"$f":"NHD*NVD","v":0}]
[null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(AND(RETTYPE=2,DTYP=4,HD=TRUE)),DCVRSH+2,IF(AND(AND(RETTYPE=3,DTYP=4,HD=TRUE)),DCVRSH+2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(AND(RETTYPE=2,DTYP=4,HD=TRUE)),\"5170\",IF(AND(AND(RETTYPE=3,DTYP=4,HD=TRUE)),\"5170\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(AND(AND(RETTYPE=2,DTYP=4,HD=TRUE)),\" Divider Cover Screw - 1/4 - 20 x 1/2'' S.S. Allen Head Machine Screw - One (1) Every 48'' on Center - (Horizontal Divider/s )\",IF(AND(AND(RETTYPE=3,DTYP=4,HD=TRUE)),\" Divider Cover Screw - 1/4 - 20 x 1/2'' S.S. Allen Head Machine Screw - One (1) Every 48'' on Center - ( Horizontal Divider/s )\",\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(HD=FALSE,\"\",IF(RETTYPE=1,\"\",IF(RETTYPE=4,\"\",IF(AND(RETTYPE=3,DTYP<=2),\"\",IF(AND(BodyType<=3,HD=TRUE),KQ*NHD*(ROUNDUP(Wdt/48,0)+1),IF(AND(HD=TRUE,OR(BodyType=4,BodyType=5)),KQ*NHD*(ROUNDUP(Wdt/48,0)+1)*2,IF(AND(BodyType>=6,HD=TRUE),KQ*NHD*(ROUNDUP(Wdt/48,0)+1),\"\")))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(AND(RETTYPE=2,DTYP=4,VD=TRUE)),DCVRSV+2,IF(AND(AND(RETTYPE=3,DTYP=4,VD=TRUE)),DCVRSV+2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(AND(RETTYPE=2,DTYP=4,VD=TRUE)),\"5170\",IF(AND(AND(RETTYPE=3,DTYP=4,VD=TRUE)),\"5170\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(AND(AND(RETTYPE=2,DTYP=4,VD=TRUE)),\" Divider Cover Screw - 1/4 - 20 x 1/2'' S.S. Allen Head Machine Screw - One (1) Every 48'' on Center - (Vertical Divider/s )\",IF(AND(AND(RETTYPE=3,DTYP=4,VD=TRUE)),\" Divider Cover Screw - 1/4 - 20 x 1/2'' S.S. Allen Head Machine Screw - One (1) Every 48'' on Center - ( Vertical Divider/s )\",\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=1,\"\",IF(VD=FALSE,\"\",IF(RETTYPE=1,\"\",IF(RETTYPE=4,\"\",IF(AND(RETTYPE=3,DTYP<=2),\"\",IF(AND(BodyType<=3,VD=TRUE),KQ*NVD*(ROUNDUP(Hgt/48,0)+1),IF(AND(VD=TRUE,OR(BodyType=4,BodyType=5)),KQ*NVD*(ROUNDUP(Hgt/48,0)+1)*2,IF(AND(BodyType>=6,VD=TRUE),KQ*NVD*(ROUNDUP(Hgt/48,0)+1),\"\")))))))))","v":""}]
[null,"Inner Frame"]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(BodyType<=3,INFRM>=1),KQ*4,IF(AND(BodyType=4,INFRM>=1),KQ*8,IF(AND(BodyType=5,INFRM>=1),KQ*8,IF(AND(BodyType>=6,INFRM>=1),KQ*4,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(OTFRM=1,\"5210\",IF(OTFRM=2,\"5210\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(INFRM=1,\" Corner Key - .120'' Stamped Aluminum - One (1) per corner\",IF(INFRM=2,\" Corner Key - .120'' Stamped Aluminum - One (1) per corner\",\"\"))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(BodyType<=3,INFRM=2),KQ*4,IF(AND(BodyType=4,INFRM=2),KQ*8,IF(AND(BodyType=5,INFRM=2),KQ*8,IF(AND(BodyType>=6,INFRM=2),KQ*4,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(INFRM=1,\"\",IF(INFRM=2,\"5305\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(INFRM=2,\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (1-1/16'') Aluminum Angle - One (1) per corner\",\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(INFRM=2,\"\",IF(BodyType<=3,KQ*6,IF(BodyType=4,KQ*10,IF(BodyType=5,KQ*10,IF(BodyType>=6,KQ*6,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(INFRM=1,\"5241\"&PPTD,\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(INFRM=1,\" Corner Screw - #8 x 3/4'' Sq/Phillips Counter Sink S.S. Screw - Type A - One (1) per corner\",\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(BodyType<=3,((ROUNDDOWN(Wdt/36,0)+1)+2)*KQ,IF(AND(BodyType>=4,BodyType<=5),(((ROUNDDOWN(Wdt/36,0)+1)*2)+2)*KQ,IF(BodyType>=6,((ROUNDDOWN(Wdt/36,0)+1)+2)*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(INFRM>=1,\"5170\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(INFRM>=1,\" Hinge Screw - 1/4-20 x 1/2'' Allen Head S.S. Machine Screw - One (1) every 36'' on center\",\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(BodyType<=3,(CS+2)*KQ,IF(AND(BodyType>=4,BodyType<=5),((CS*2)+2)*KQ,IF(BodyType>=6,(CS+2)*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(INFRM>=1,\"5180\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(INFRM>=1,\" Closure Screw - 1/4-20 x 3/4'' Sq/Phillips Pan Head S.S. Machine Screw - One (1) every 48'' on center\",\"\")))","v":""}]
[null,"Outer Frame"]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"##\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(AND(BodyType<=3,OTFRM=2),KQ*4,IF(AND(BodyType=4,OTFRM=2),KQ*8,IF(AND(BodyType=5,OTFRM=2),KQ*8,IF(AND(BodyType>=6,OTFRM=2),KQ*4,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"####\",IF(AND(INFRM=2,OTFRM=1),\"####\",IF(OTFRM=2,\"5210\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"#####\",IF(AND(INFRM=2,OTFRM=1),\"#####\",IF(OTFRM=2,\" Corner Key - .120'' Stamped Aluminum - One (1) per corner\",\"\")))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"##\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(AND(BodyType<=3,OTFRM=1),KQ*8,IF(AND(BodyType=4,OTFRM=1),KQ*16,IF(AND(BodyType=5,OTFRM=1),KQ*16,IF(AND(BodyType>=6,OTFRM=1),KQ*8,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"####\",IF(AND(INFRM=2,OTFRM=1),\"####\",IF(OTFRM=1,\"5975\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"#####\",IF(AND(INFRM=2,OTFRM=1),\"#####\",IF(OTFRM=1,\" Outer Frame Corner Angle - 2'' x 2'' x 1/8'' (3/8'') - Two (2) per corner\",\"\")))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"##\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(AND(BodyType<=3,OTFRM=2),KQ*8,IF(AND(BodyType=4,OTFRM=2),KQ*16,IF(AND(BodyType=5,OTFRM=2),KQ*16,IF(AND(BodyType>=6,OTFRM=2),KQ*8,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"####\",IF(AND(INFRM=2,OTFRM=1),\"####\",IF(OTFRM=2,\"5305\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"#####\",IF(AND(INFRM=2,OTFRM=1),\"#####\",IF(OTFRM=2,\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' (1-1/16'') Aluminum Angle - Two (2) per corner\",\"\")))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"\",IF(AND(INFRM=2,OTFRM=1),\"\",IF(AND(BodyType<=3,OTFRM=1),KQ*18,IF(AND(BodyType=4,OTFRM=1),KQ*34,IF(AND(BodyType=5,OTFRM=1),KQ*34,IF(AND(BodyType>=6,OTFRM=1),KQ*18,IF(AND(BodyType<=3,OTFRM=2),KQ*10,IF(AND(BodyType=4,OTFRM=2),KQ*18,IF(AND(BodyType=5,OTFRM=2),KQ*18,IF(AND(BodyType>=6,OTFRM=2),KQ*10,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"\",IF(AND(INFRM=2,OTFRM=1),\"\",IF(OTFRM=1,\"5990\",IF(OTFRM=2,\"5990\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"####\",IF(AND(INFRM=2,OTFRM=1),\"#####\",IF(OTFRM=1,\" Outer Frame Corner Angle Screw - #8 x 3/8'' Sq/Phillips Counter Sunk S.S. Screw - Type A - Four (4) per corner\",IF(OTFRM=2,\" 2Part Large Hinge Screw - #8 x 3/8'' Sq/Phillips Counter Sunk S.S. Screw - Type A - Two (2) per corner\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"##\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(AND(BodyType<=3,OTFRM=2),KQ*10,IF(AND(BodyType=4,OTFRM=2),KQ*18,IF(AND(BodyType=5,OTFRM=2),KQ*18,IF(AND(BodyType>=6,OTFRM=2),KQ*10,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"####\",IF(AND(INFRM=2,OTFRM=1),\"####\",IF(OTFRM=2,\"5218\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"#####\",IF(AND(INFRM=2,OTFRM=1),\"#####\",IF(OTFRM=2,\" Frame Corner Angle Screw - #10 x 1/2'' Sq/Phillips Pan Head S.S. Screw - Type AB - Two (2) per corner\",\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"##\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(BodyType<=3,KQ*2,IF(AND(BodyType>=4,BodyType<=5),KQ*4,IF(BodyType>=6,KQ*2,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"####\",IF(AND(INFRM=2,OTFRM=1),\"####\",IF(OTFRM=1,\"5994\",IF(OTFRM=2,\"5993\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"#####\",IF(AND(INFRM=2,OTFRM=1),\"#####\",IF(OTFRM=1,\" 2Part Lock - Two (2) per Outer Frame\",IF(OTFRM=2,\" 2Part Large Lock - Two (2) per Outer Frame\",\"\"))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"##\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(AND(INFRM=2,OTFRM=2),\"\",IF(BodyType<=3,1,IF(AND(BodyType>=4,BodyType<=5),1,IF(BodyType>=6,1,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"####\",IF(AND(INFRM=2,OTFRM=1),\"####\",IF(OTFRM=1,\"5992\",IF(OTFRM=2,\"\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=2),\"#####\",IF(AND(INFRM=2,OTFRM=1),\"#####\",IF(OTFRM=1,\" 2Part Lock Wrench\",IF(OTFRM=2,\"\",\"\"))))))","v":""}]
[null,"Hinge"]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=1),\"\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(AND(BodyType<=3,OTFRM=2),HingScrs+2,IF(AND(AND(BodyType>=4,BodyType<=5,OTFRM=2)),(HingScrs*2)+2,IF(AND(BodyType>=6,OTFRM=2),HingScrs+2,\"\")))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=2,OTFRM=1),\"####\",IF(AND(OTFRM=2,Hinge=1),\"5990\",IF(AND(OTFRM=2,Hinge=2),\"5990\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=2,OTFRM=1),\"#####\",IF(AND(OTFRM=2,Hinge=1),\" 2Part Large Hinge Screw - #8 x 3/8'' Sq/Phillips Counter Sunk S.S. Screw - Type-A\",IF(AND(OTFRM=2,Hinge=2),\" 2Part Large Hinge Screw - #8 x 3/8'' Sq/Phillips Counter Sunk S.S. Screw - Type-A\",\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OTFRM=2,Hinge=1),(((Wdt-36)/6)+12)*2,IF(AND(OTFRM=2,Hinge=2),(((Hgt-36)/6)+12)*2,\"\"))","v":""},"Hinge Screws"]
[null,"Gas Supports"]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=1),\"\",IF(AND(INFRM=1,OTFRM=2),\"##\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(Hinge=2,\"\",IF(AND(BodyType<=3,OTFRM=2),KQ*1,IF(AND(BodyType=4,OTFRM=2),KQ*2,IF(AND(BodyType=5,OTFRM=2),KQ*2,IF(AND(BodyType>=6,OTFRM=2),KQ*1,\"\"))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=1),\"\",IF(AND(INFRM=1,OTFRM=2),\"##\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(Hinge=2,\"\",IF(AND(INFRM=2,OTFRM=2),'Gas Support'!$C$39)))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=1),\"\",IF(AND(INFRM=1,OTFRM=2),\"##\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(Hinge=2,\"\",IF(AND(INFRM=2,OTFRM=2),\" Gas Supports - Two (2) Per Face\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=1),\"\",IF(AND(INFRM=1,OTFRM=2),\"##\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(Hinge=2,\"\",IF(AND(INFRM=2,OTFRM=2),'Gas Support'!$C$61,\"\")))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(NOYES=1,\"\",IF(AND(INFRM=1,OTFRM=1),\"\",IF(AND(INFRM=1,OTFRM=2),\"##\",IF(AND(INFRM=2,OTFRM=1),\"##\",IF(Hinge=2,\"\",IF(GSPLMT=\"A\",\" See Gas Support Placement ''A'' Instruction Sheet\",IF(GSPLMT=\"B\",\" See Gas Support Placement ''B'' Instruction Sheet\",IF(GSPLMT=\"C\",\" See Gas Support Placement ''C'' Instruction Sheet\",\"\")))))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,"BILL OF MATERIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(FST=1,\"\",IF(NOYES=2,\"\",IF(RETTYPE<=2,\"\",IF(RETTYPE=6,\"\",IF(RETTYPE=7,\"\",IF(AND(AND(BodyType=1,RETTYPE=3,FBTYP=1)),\"2177\",IF(AND(AND(BodyType=1,RETTYPE=3,FBTYP=2)),\"\",IF(AND(AND(BodyType=1,RETTYPE=3,FBTYP=3)),\"2177\",IF(AND(AND(BodyType=2,RETTYPE=3,FBTYP=1)),\"2175\",IF(AND(AND(BodyType=2,RETTYPE=3,FBTYP=2)),\"\",IF(AND(AND(BodyType=2,RETTYPE=3,FBTYP=3)),\"2175\",IF(AND(AND(BodyType=3,RETTYPE=3,FBTYP=1)),\"2175\",IF(AND(AND(BodyType=3,RETTYPE=3,FBTYP=2)),\"2175\",IF(AND(AND(BodyType=3,RETTYPE=3,FBTYP=3)),\"2175\",IF(AND(AND(BodyType=4,RETTYPE=3,FBTYP=1)),\"2175\",IF(AND(AND(BodyType=4,RETTYPE=3,FBTYP=2)),\"2175\",IF(AND(AND(BodyType=4,RETTYPE=3,FBTYP=3)),\"2175\",IF(AND(AND(BodyType=5,RETTYPE=3,FBTYP=1)),\"2175\",IF(AND(AND(BodyType=5,RETTYPE=3,FBTYP=2)),\"2175\",IF(AND(AND(BodyType=5,RETTYPE=3,FBTYP=3)),\"2175\",IF(AND(AND(BodyType=6,RETTYPE=3,FBTYP>=1)),\"2175\",IF(AND(AND(BodyType=7,RETTYPE=3,FBTYP>=1)),\"\",IF(AND(AND(BodyType=1,FBTYP=1,OR(RETTYPE=4,RETTYPE=5))),\"2177\",IF(AND(AND(BodyType=1,FBTYP=2,OR(RETTYPE=4,RETTYPE=5))),\"\",IF(AND(AND(BodyType=1,FBTYP=3,OR(RETTYPE=4,RETTYPE=5))),\"2177\",IF(AND(AND(BodyType=2,FBTYP=1,OR(RETTYPE=4,RETTYPE=5))),\"2175\",IF(AND(AND(BodyType=2,FBTYP=2,OR(RETTYPE=4,RETTYPE=5))),\"\",IF(AND(AND(BodyType=2,FBTYP=3,OR(RETTYPE=4,RETTYPE=5))),\"2175\",IF(AND(AND(BodyType=3,FBTYP=1,OR(RETTYPE=4,RETTYPE=5))),\"2175\",IF(AND(AND(BodyType=3,FBTYP=2,OR(RETTYPE=4,RETTYPE=5))),\"2175\",IF(AND(AND(BodyType=3,FBTYP=3,OR(RETTYPE=4,RETTYPE=5))),\"2175\",IF(AND(AND(BodyType=4,FBTYP=1,OR(RETTYPE=4,RETTYPE=5))),\"2175\",IF(AND(AND(BodyType=4,FBTYP=2,OR(RETTYPE=4,RETTYPE=5))),\"2175\",IF(AND(AND(BodyType=4,FBTYP=3,OR(RETTYPE=4,RETTYPE=5))),\"2175\",IF(AND(AND(BodyType=5,FBTYP=1,OR(RETTYPE=4,RETTYPE=5))),\"2175\",IF(AND(AND(BodyType=5,FBTYP=2,OR(RETTYPE=4,RETTYPE=5))),\"2175\",IF(AND(AND(BodyType=5,FBTYP=3,OR(RETTYPE=4,RETTYPE=5))),\"2175\",IF(AND(AND(BodyType=6,FBTYP>=1,OR(RETTYPE=4,RETTYPE=5))),\"2175\",IF(AND(AND(BodyType=7,FBTYP>=1,OR(RETTYPE=4,RETTYPE=5))),\"\",IF(AND(AND(BodyType=1,FBTYP=1,OR(RETTYPE=8,RETTYPE=9))),\"2177\",IF(AND(AND(BodyType=1,FBTYP=2,OR(RETTYPE=8,RETTYPE=9))),\"\",IF(AND(AND(BodyType=1,FBTYP=3,OR(RETTYPE=8,RETTYPE=9))),\"2177\",IF(AND(AND(BodyType=2,FBTYP=1,OR(RETTYPE=8,RETTYPE=9))),\"2177\",IF(AND(AND(BodyType=2,FBTYP=2,OR(RETTYPE=8,RETTYPE=9))),\"\",IF(AND(AND(BodyType=2,FBTYP=3,OR(RETTYPE=8,RETTYPE=9))),\"2177\",IF(AND(AND(BodyType=3,FBTYP=1,OR(RETTYPE=8,RETTYPE=9))),\"2175\",IF(AND(AND(BodyType=3,FBTYP=2,OR(RETTYPE=8,RETTYPE=9))),\"2175\",IF(AND(AND(BodyType=3,FBTYP=3,OR(RETTYPE=8,RETTYPE=9))),\"2175\",IF(AND(AND(BodyType=4,FBTYP=1,OR(RETTYPE=8,RETTYPE=9))),\"2177\",IF(AND(AND(BodyType=4,FBTYP=2,OR(RETTYPE=8,RETTYPE=9))),\"2177\",IF(AND(AND(BodyType=4,FBTYP=3,OR(RETTYPE=8,RETTYPE=9))),\"2177\",IF(AND(AND(BodyType=5,FBTYP=1,OR(RETTYPE=8,RETTYPE=9))),\"2177\",IF(AND(AND(BodyType=5,FBTYP=2,OR(RETTYPE=8,RETTYPE=9))),\"2177\",IF(AND(AND(BodyType=5,FBTYP=3,OR(RETTYPE=8,RETTYPE=9))),\"2175\",IF(AND(AND(BodyType=6,FBTYP>=1,OR(RETTYPE=8,RETTYPE=9))),\"2177\",IF(AND(AND(BodyType=7,FBTYP>=1,OR(RETTYPE=8,RETTYPE=9))),\"\",\"\")))))))))))))))))))))))))))))))))))))))))))))))))))))))))","v":""}]
[null,{"$f":"DIS","v":""}]
[]
[null,"Customer  ",null,null,null,{"$f":"IF(Cust=0,\"\",Cust)","v":""},null,null,null,null,null,null,null,null,"Order#   ",null,null,null,{"$f":"IF(Ordnum=0,\"\",Ordnum)","v":""}]
[null,"Kit Quantity  ",null,null,null,{"$f":"IF(KQ=0,\"\",KQ)","v":""},null,"Height  ",null,null,null,{"$f":"IF(KQ=0,\"\",Hgt)","v":""},null,"Width",null,null,null,{"$f":"IF(KQ=0,\"\",Wdt)","v":""}]
[]
[null,"Hardware Summary"]
[]
[null,null,5312,null,{"$f":"SUMIF(C73:C112,C131,B73:B112)","v":0},null,5180,null,{"$f":"SUMIF(C73:C112,G131,B73:B112)","v":0},null,{"$f":"C89","v":""},null,{"$f":"SUMIF(C75:C114,K131,B75:B114)","v":0}]
[null,null,5318,null,{"$f":"SUMIF(C73:C112,C132,B73:B112)","v":0},null,5975,null,{"$f":"SUMIF(C73:C112,G132,B73:B112)","v":0}]
[null,null,5322,null,{"$f":"SUMIF(C73:C112,C133,B73:B112)","v":0},null,5990,null,{"$f":"SUMIF(C73:C112,G133,B80:B112)","v":0}]
[null,null,5321,null,{"$f":"SUMIF(C73:C112,C134,B73:B112)","v":0},null,5993,null,{"$f":"SUMIF(C80:C112,G134,B73:B112)","v":0}]
[null,null,5320,null,{"$f":"SUMIF(C73:C112,C135,B73:B112)","v":0},null,5994,null,{"$f":"SUMIF(C73:C112,G135,B73:B112)","v":0}]
[null,null,5218,null,{"$f":"SUMIF(C73:C112,C136,B73:B112)","v":0},null,5992,null,{"$f":"SUMIF(C73:C112,G136,B73:B112)","v":0}]
[null,null,5210,null,{"$f":"SUMIF(C73:C112,C137,B73:B112)","v":0},null,5304,null,{"$f":"SUMIF(C73:C112,G137,B73:B112)","v":0}]
[null,null,5305,null,{"$f":"SUMIF(C73:C112,C138,B73:B112)","v":0},null,5195,null,{"$f":"SUMIF(C73:C112,G138,B73:B112)","v":0}]
[null,null,5241,null,{"$f":"SUMIF(C73:C112,C139,B73:B112)","v":0},null,5168,null,{"$f":"SUMIF(C73:C112,G139,B73:B112)","v":0}]
[null,null,"5241P",null,{"$f":"SUMIF(C73:C112,C140,B73:B112)","v":0},null,{"$f":"C85","v":""},null,{"$f":"SUMIF(C74:C113,G140,B74:B113)","v":0}]
[null,null,5170,null,{"$f":"SUMIF(C73:C112,C141,B73:B112)","v":0},null,5360,null,{"$f":"SUMIF(C75:C114,G141,B75:B114)","v":0}]

{"sheet":"Gas Support","index":1,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":true,"merged":[[60,0,60,1],[20,0,20,1],[22,0,22,1],[38,0,38,1],[42,0,42,1],[44,0,44,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"HT","Width"]
["Actual Cabinet Size",null,{"$f":"[0]!Hgt","v":0},{"$f":"[0]!Wdt","v":0},null,null,{"$f":"IF(AH>=90,\"\",IF(AH>=84,84,IF(AH>=78,78,IF(AH>=72,72,IF(AH>=66,66,IF(AH>=60,60,IF(AH>=54,54,IF(AH>=48,48,IF(AH>=42,42,IF(AH>=36,36,IF(AH>=30,30,IF(AH>=24,24))))))))))))","v":false}]
[]
["Nominal Cabinet Size",null,{"$f":"G21","v":false},{"$f":"G23","v":false},null,null,{"$f":"IF(AW>=150,\"\",IF(AW>=144,144,IF(AW>=132,132,IF(AW>=120,120,IF(AW>=108,108,IF(AW>=96,96,IF(AW>=84,84,IF(AW>=72,72,IF(AW>=60,60,IF(AW>=48,48,IF(AW>=36,36)))))))))))","v":false}]
[]
[null,null,null,"WIDTH"]
[null,null,null,36,48,60,72,84,96,108,120,132,144]
[null,"HT",24,"K5933-30","K5933-30","K5933-40","K5933-40","K5933-50","K5933-50","K5933-50","K5933-60","K5933-60","K5933-70"]
[null,null,30,"K5934-30","K5934-30","K5934-30","K5934-40","K5934-40","K5934-40","K5934-50","K5934-50","K5934-50","K5934-60"]
[null,null,36,"K5934-30","K5934-30","K5934-40","K5934-50","K5934-50","K5934-60","K5934-60","K5934-70","K5934-70","K5934-70"]
[null,null,42,"K5934-40","K5934-50","K5934-50","K5934-60","K5934-60","K5934-70","K5934-80","K5934-80","K5934-90","K5934-90"]
[null,null,48,"K5934-50","K5934-60","K5934-60","K5934-70","K5934-80","K5934-90","K5934-90","K5934-100","K5934-110","K5934-110"]
[null,null,54,"K5934-60","K5934-70","K5934-80","K5934-80","K5934-90","K5934-100","K5934-110","K5934-120","K5934-130","K5934-140"]
[null,null,60,"K5934-70","K5934-80","K5934-90","K5934-100","K5934-110","K5934-120","K5934-130","K5934-140","K5934-160","K5934-170"]
[null,null,66,"K5934-80","K5934-90","K5934-100","K5934-120","K5934-130","K5934-140","K5934-150","K5934-170","K5934-180","K5934-110"]
[null,null,72,"K5934-90","K5934-100","K5934-120","K5934-130","K5934-150","K5934-160","K5934-180","K5934-110","K5934-110","K5934-120"]
[null,null,78,"K5934-60","K5934-70","K5934-80","K5934-80","K5934-90","K5934-100","K5934-110","K5934-120","K5934-130","K5934-140"]
[null,null,84,"K5934-60","K5934-70","K5934-80","K5934-90","K5934-100","K5934-120","K5934-130","K5934-140","K5934-150","K5934-160"]
[]
["Gas Support Required",null,{"$f":"INDEX(D27:M37,MATCH(HT,C27:C37,0),MATCH(WTH,D26:M26,0))","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(AH>=90,\"\",IF(AH>=84,84,IF(AH>=78,78,IF(AH>=72,72,IF(AH>=66,66,IF(AH>=60,60,IF(AH>=54,54,IF(AH>=48,48,IF(AH>=42,42,IF(AH>=36,36,IF(AH>=30,30,IF(AH>=24,24))))))))))))","v":false}]
[]
["Nominal Cabinet Size",null,{"$f":"G43","v":false},{"$f":"G45","v":false},null,null,{"$f":"IF(AW>=150,\"\",IF(AW>=144,144,IF(AW>=132,132,IF(AW>=120,120,IF(AW>=108,108,IF(AW>=96,96,IF(AW>=84,84,IF(AW>=72,72,IF(AW>=60,60,IF(AW>=48,48,IF(AW>=36,36)))))))))))","v":false}]
[]
[null,null,null,"WIDTH"]
[null,null,null,36,48,60,72,84,96,108,120,132,144]
[null,"HT",24,"A","A","A","A","A","A","A","A","A","A"]
[null,null,30,"B","B","B","B","B","B","B","B","B","B"]
[null,null,36,"B","B","B","B","B","B","B","B","B","B"]
[null,null,42,"B","B","B","B","B","B","B","B","B","B"]
[null,null,48,"B","B","B","B","B","B","B","B","B","B"]
[null,null,54,"B","B","B","B","B","B","B","B","B","B"]
[null,null,60,"B","B","B","B","B","B","B","B","B","B"]
[null,null,66,"B","B","B","B","B","B","B","B","B","C"]
[null,null,72,"B","B","B","B","B","B","B","C","C","C"]
[null,null,78,"C","C","C","C","C","C","C","C","C","C"]
[null,null,84,"C","C","C","C","C","C","C","C","C","C"]
[]
["Gas Support Placement",null,{"$f":"INDEX(D49:M59,MATCH(HT,C49:C59,0),MATCH(WTH,D48:M48,0))","v":{"$error":"#N/A"}}]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Flex Face Dimensions","index":3,"n_rows":58,"n_cols":31,"rows_kept":58,"cut":false,"hidden":false,"merged":[[54,1,54,28],[55,7,55,12],[55,13,55,14],[55,15,55,24],[57,13,57,14],[57,8,57,12],[57,15,57,27],[34,1,34,28],[35,1,35,28],[52,1,52,28],[53,8,53,12],[53,13,53,14],[53,15,53,24],[33,1,33,28],[30,3,30,9],[30,10,30,11],[30,13,30,19],[30,20,30,21],[30,22,30,28],[31,1,31,28],[32,3,32,9],[32,10,32,11],[32,13,32,19],[32,20,32,21],[32,22,32,28],[29,1,29,28],[8,1,8,28],[25,1,25,28],[26,1,26,4],[26,5,26,21],[26,22,26,28],[27,1,27,28],[28,3,28,9],[28,10,28,11],[28,13,28,19],[28,20,28,21],[28,22,28,28],[7,1,7,28],[1,1,1,28],[2,1,2,28],[3,1,3,28],[4,1,5,28],[6,1,6,28]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Face Trim Size Calculations"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Frame Type:",null,null,null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=2,\"\",IF(NOYES=2,\"\",IF(RETTYPE=3,\"Dual Frame with 2-/4'' Dual Frame Cover\",IF(RETTYPE=4,\"Tension Frame with Bleed Tension Frame Cover\",IF(RETTYPE=5,\"1-1/2'' Tension Frame Cover\",\"\"))))))","v":""}]
[]
[null,null,null,"Outside Frame dimension (Height) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=2,\"\",IF(NOYES=2,\"\",IF(BodyType=7,Fhgt,IF(RETTYPE=3,Bhgt,IF(RETTYPE=4,Bhgt,IF(RETTYPE=5,Bhgt,IF(RETTYPE=8,Bhgt,IF(RETTYPE=9,Bhgt,\"\")))))))))","v":""},null,null,"Outside Frame Dimension (Width) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=2,\"\",IF(NOYES=2,\"\",IF(BodyType=7,Fwdt,IF(RETTYPE=3,Bwdt,IF(RETTYPE=4,Bwdt,IF(RETTYPE=5,Bwdt,IF(RETTYPE=8,Bwdt,IF(RETTYPE=9,Bwdt,\"\")))))))))","v":""}]
[]
[null,null,null,"Visual Opening (Height) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=2,\"\",IF(NOYES=2,\"\",IF(RETTYPE=3,FrmHgt-4.5,IF(RETTYPE=4,FrmHgt-0.5,IF(RETTYPE=5,FrmHgt-3,IF(RETTYPE=8,FrmHgt-0.5,IF(RETTYPE=9,FrmHgt-3,\"\"))))))))","v":""},null,null,"Visual Opening (Width) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=2,\"\",IF(NOYES=2,\"\",IF(RETTYPE=3,FrmWdt-4.5,IF(RETTYPE=4,FrmWdt-0.5,IF(RETTYPE=5,FrmWdt-3,IF(RETTYPE=8,FrmWdt-0.5,IF(RETTYPE=9,FrmWdt-3,\"\"))))))))","v":""}]
[]
[null,null,null,"Face Trim Size (Height) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=2,\"\",IF(NOYES=2,\"\",IF(RETTYPE=3,FrmHgt+3,IF(RETTYPE=4,FrmHgt+6,IF(RETTYPE=5,FrmHgt+6,IF(RETTYPE=8,FrmHgt+6.5,IF(RETTYPE=9,FrmHgt+6.5,\"\"))))))))","v":""},null,null,"Face Trim Size (Width) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=2,\"\",IF(NOYES=2,\"\",IF(RETTYPE=3,FrmWdt+3,IF(RETTYPE=4,FrmWdt+6,IF(RETTYPE=5,FrmWdt+6,IF(RETTYPE=8,FrmWdt+6.5,IF(RETTYPE=9,FrmWdt+6.5,\"\"))))))))","v":""}]
[]
[]
[null,"Clip Line Calculations"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Clip Line Placement ",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=2,\"\",IF(NOYES=2,\"\",IF(RETTYPE=3,\"1-1/2''\",IF(RETTYPE=4,\"1-1/2''\",IF(RETTYPE=5,\"1-1/2''\",IF(RETTYPE=8,\"1-1/2''\",IF(RETTYPE=9,\"1-1/2''\",\"\"))))))))","v":""},null,"(In from the trimmed edge of the face.)"]
[]
[null,null,null,null,null,null,null,"Clip Spacing ",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=2,\"\",IF(NOYES=2,\"\",IF(RETTYPE=3,\"6''\",IF(RETTYPE=4,\"5''\",IF(RETTYPE=5,\"5''\",IF(RETTYPE=8,\"5''\",IF(RETTYPE=9,\"5''\",\"\"))))))))","v":""},null,"(Center to Center)"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=2,\"\",IF(NOYES=2,\"\",IF(RETTYPE=3,\"Tensioning Tool Part # \",IF(RETTYPE=4,\"Tensioning Tool Part # \",IF(RETTYPE=5,\"Tensioning Tool Part # \",\"\"))))))","v":""},null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(NoYes2=2,\"\",IF(NOYES=2,\"\",IF(RETTYPE=3,\"5135\",IF(RETTYPE=4,\"5135\",IF(RETTYPE=5,\"5135\",IF(RETTYPE=8,\"5135\",IF(RETTYPE=9,\"5135\",\"\"))))))))","v":""},null,"( See Commercial Catalog Pg.13 or Contact Customer Service)"]

{"sheet":"GS Placement A","index":4,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,1,4,13],[5,1,6,13],[73,1,76,13]]}
[null,"S  I  G  N  C  O  M  P       S  Y  S  T  E  M  S      A  N  D      E  X  T  R  U  S  I  O  N  S"]
[]
[]
[]
[]
[null,"  2Part Large Vandal Cover and Large Vandal Cover"]
[]
[]
[null,null,"Gas Support Placement and Poundage Table:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Weight table for door in lbs."]
[]
[null,null,null,"Width"]
[null,null,"Height",36,48,60,72,84,96,108,120,132,144]
[null,null,24,16,20,24,28,32,37,41,45,49,53]
[null,null,30,19,23,28,33,37,42,47,51,56,60]
[null,null,36,21,26,32,37,42,47,52,58,63,68]
[null,null,42,24,30,35,41,47,53,58,64,70,76]
[null,null,48,26,33,39,45,52,58,64,70,77,83]
[null,null,54,29,36,43,50,56,63,70,77,84,91]
[null,null,60,32,39,46,54,61,69,76,83,91,98]
[null,null,66,34,42,50,58,66,74,82,90,98,106]
[null,null,72,37,45,54,62,71,79,88,96,105,113]
[null,null,78,39,48,58,67,76,85,94,103,112,121]
[null,null,84,42,52,61,71,80,90,100,109,119,128]
[]
[null,null,"Poundage per Gas Support in lbs. (2 Gas Supports per door)"]
[]
[null,null,null,"Width"]
[null,null,"Height",36,48,60,72,84,96,108,120,132,144]
[null,null,24,30,30,40,40,50,50,50,60,60,70]
[null,null,30,30,30,30,40,40,40,50,50,50,60]
[null,null,36,30,30,40,50,50,60,60,70,70,70]
[null,null,42,40,50,50,60,60,70,80,80,90,90]
[null,null,48,50,60,60,70,80,90,90,100,110,110]
[null,null,54,60,70,80,80,90,100,110,120,130,140]
[null,null,60,70,80,90,100,110,120,130,140,160,170]
[null,null,66,80,90,100,120,130,140,150,170,180,110]
[null,null,72,90,100,120,130,150,160,180,110,110,120]
[null,null,78,60,70,80,80,90,100,110,120,130,140]
[null,null,84,60,70,80,90,100,120,130,140,150,160]
[]
[null,null,null,null,"Placement \"A\" #5933 Gas Support (Special Order Only)"]
[null,null,null,null,"Placement \"B\" #5934 Gas Support ( Stock Item)"]
[null,null,null,null,"Placement \"B\" #5934 Gas Support (Special Order Only)"]
[null,null,null,null,"Placement \"C\" #5934 Gas Support ( Stock Item)"]
[null,null,null,null,"Placement \"C\" #5934 Gas Support (Special Order Only)"]

{"sheet":"GS Placement B","index":5,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,1,4,13],[5,1,6,13],[73,1,76,13]]}
[null,"S  I  G  N  C  O  M  P       S  Y  S  T  E  M  S      A  N  D      E  X  T  R  U  S  I  O  N  S"]
[]
[]
[]
[]
[null,"  2Part Large Vandal Cover and Large Vandal Cover"]
[]
[]
[null,null,"Gas Support Placement and Poundage Table:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Weight table for door in lbs."]
[]
[null,null,null,"Width"]
[null,null,"Height",36,48,60,72,84,96,108,120,132,144]
[null,null,24,16,20,24,28,32,37,41,45,49,53]
[null,null,30,19,23,28,33,37,42,47,51,56,60]
[null,null,36,21,26,32,37,42,47,52,58,63,68]
[null,null,42,24,30,35,41,47,53,58,64,70,76]
[null,null,48,26,33,39,45,52,58,64,70,77,83]
[null,null,54,29,36,43,50,56,63,70,77,84,91]
[null,null,60,32,39,46,54,61,69,76,83,91,98]
[null,null,66,34,42,50,58,66,74,82,90,98,106]
[null,null,72,37,45,54,62,71,79,88,96,105,113]
[null,null,78,39,48,58,67,76,85,94,103,112,121]
[null,null,84,42,52,61,71,80,90,100,109,119,128]
[]
[null,null,"Poundage per Gas Support in lbs. (2 Gas Supports per door)"]
[]
[null,null,null,"Width"]
[null,null,"Height",36,48,60,72,84,96,108,120,132,144]
[null,null,24,30,30,40,40,50,50,50,60,60,70]
[null,null,30,30,30,30,40,40,40,50,50,50,60]
[null,null,36,30,30,40,50,50,60,60,70,70,70]
[null,null,42,40,50,50,60,60,70,80,80,90,90]
[null,null,48,50,60,60,70,80,90,90,100,110,110]
[null,null,54,60,70,80,80,90,100,110,120,130,140]
[null,null,60,70,80,90,100,110,120,130,140,160,170]
[null,null,66,80,90,100,120,130,140,150,170,180,110]
[null,null,72,90,100,120,130,150,160,180,110,110,120]
[null,null,78,60,70,80,80,90,100,110,120,130,140]
[null,null,84,60,70,80,90,100,120,130,140,150,160]
[]
[null,null,null,null,"Placement \"A\" #5933 Gas Support (Special Order Only)"]
[null,null,null,null,"Placement \"B\" #5934 Gas Support ( Stock Item)"]
[null,null,null,null,"Placement \"B\" #5934 Gas Support (Special Order Only)"]
[null,null,null,null,"Placement \"C\" #5934 Gas Support ( Stock Item)"]
[null,null,null,null,"Placement \"C\" #5934 Gas Support (Special Order Only)"]

{"sheet":"GS Placement C","index":6,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,1,4,13],[5,1,6,13],[73,1,76,13]]}
[null,"S  I  G  N  C  O  M  P       S  Y  S  T  E  M  S      A  N  D      E  X  T  R  U  S  I  O  N  S"]
[]
[]
[]
[]
[null,"  2Part Large Vandal Cover and Large Vandal Cover"]
[]
[]
[null,null,"Gas Support Placement and Poundage Table:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Weight table for door in lbs."]
[]
[null,null,null,"Width"]
[null,null,"Height",36,48,60,72,84,96,108,120,132,144]
[null,null,24,16,20,24,28,32,37,41,45,49,53]
[null,null,30,19,23,28,33,37,42,47,51,56,60]
[null,null,36,21,26,32,37,42,47,52,58,63,68]
[null,null,42,24,30,35,41,47,53,58,64,70,76]
[null,null,48,26,33,39,45,52,58,64,70,77,83]
[null,null,54,29,36,43,50,56,63,70,77,84,91]
[null,null,60,32,39,46,54,61,69,76,83,91,98]
[null,null,66,34,42,50,58,66,74,82,90,98,106]
[null,null,72,37,45,54,62,71,79,88,96,105,113]
[null,null,78,39,48,58,67,76,85,94,103,112,121]
[null,null,84,42,52,61,71,80,90,100,109,119,128]
[]
[]
[null,null,"Poundage per Gas Support in lbs. (2 Gas Supports per door)"]
[null,null,null,"Width"]
[null,null,"Height",36,48,60,72,84,96,108,120,132,144]
[null,null,24,30,30,40,40,50,50,50,60,60,70]
[null,null,30,30,30,30,40,40,40,50,50,50,60]
[null,null,36,30,30,40,50,50,60,60,70,70,70]
[null,null,42,40,50,50,60,60,70,80,80,90,90]
[null,null,48,50,60,60,70,80,90,90,100,110,110]
[null,null,54,60,70,80,80,90,100,110,120,130,140]
[null,null,60,70,80,90,100,110,120,130,140,160,170]
[null,null,66,80,90,100,120,130,140,150,170,180,110]
[null,null,72,90,100,120,130,150,160,180,110,110,120]
[null,null,78,60,70,80,80,90,100,110,120,130,140]
[null,null,84,60,70,80,90,100,120,130,140,150,160]
[]
[null,null,null,null,"Placement \"A\" #5933 Gas Support (Special Order Only)"]
[null,null,null,null,"Placement \"B\" #5934 Gas Support ( Stock Item)"]
[null,null,null,null,"Placement \"B\" #5934 Gas Support (Special Order Only)"]
[null,null,null,null,"Placement \"C\" #5934 Gas Support ( Stock Item)"]
[null,null,null,null,"Placement \"C\" #5934 Gas Support (Special Order Only)"]